Convert list of string to DataTable

Question

I want to convert List of string to datatable so I try:

List<string> DesignNameList = new List<string>();

  public static Mymethod...{

     parameters = ToDataTable(DesignNameList);
   }


 public static DataTable ToDataTable(List<string> list)
        {

            DataTable dataTable = new DataTable();
            foreach (var row in list)
            {
                dataTable.Rows.Add(row);
            }
            return dataTable;

        }

But I get error when foreach is being executed in line dataTable.Rows.Add(row);:

'Input array is longer than the number of columns in this table.'

What I'm doing wrong? Regards

There is little reason to do such a thing. A List<T> is probably a bit more flexible than a DT...and you certainly do not need a DataTable you created for DB updates — Ňɏssa Pøngjǣrdenlarp
– Ňɏssa Pøngjǣrdenlarp, Commented Nov 22, 2018 at 17:11

Carlo Bos · Accepted Answer · 2018-11-22 17:04:04Z

4

You'll need to add a column to the data table first. As it is created is has no columns

DataTable datatable= new DataTable();  

DataColumn workCol = datatable.Columns.Add("column_name", typeof(String));

answered Nov 22, 2018 at 17:04

Carlo Bos

3,3132 gold badges21 silver badges32 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Wallison Felipe · Accepted Answer · 2018-11-22 17:10:59Z

0

Try to exchange the loop 'foreach' by the 'for', like this:

  DataTable dataTable = new DataTable();
  for (int i = 0; i < list.Count(); i++)
  {
      dataTable.Rows.Add(list[i]);
  }
  return dataTable;

answered Nov 22, 2018 at 17:10

Wallison Felipe

192 bronze badges

1 Comment

Ňɏssa Pøngjǣrdenlarp Over a year ago

How will that make any difference given the error message?

Collectives™ on Stack Overflow

Convert list of string to DataTable

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related