Add entire row to DataTable at once using list

Question

I just want to add List as a DataTable entire row. here is the code which I have tried.

private static DataTable _table = new DataTable();

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

// tempList = {"A1","A2","A3","A4","A5","A6"}

_table.Rows.Add(tempList);

Expected output:

      col1|col2 |col3 |col4  |col5| col6
      ----+-----+-----+------+----+--
row1   A1 |  A2 | A3  |  A4  | A5 |  A6

However this is not working for me. It will insert data collection to first column.

Actual output:

      col1      |col2 |col3 |col4  |col5| col6
      ----------+-----+-----+------+----+--
row1   A1,A2,A3.|     |     |      |    |

Please help me to Add entire row using list. thank you

ideally you need to do both otherwise you can run into problems :-) — dash, Jul 04 '12 at 12:43

score 11 · Accepted Answer · answered Jul 04 '12 at 12:05

11

DataRowCollection.Add() Method expects Object[], so you should probably try:

_table.Rows.Add(tempList.ToArray());

answered Jul 04 '12 at 12:05

MarcinJuraszek

124,003
15
196
263

score 6 · Answer 2 · answered Jul 04 '12 at 12:05

6

Rows.Add() accepts parms[], you can achieve it by converting your list into an array.

_table.Rows.Add(tempList.ToArray());

answered Jul 04 '12 at 12:05

Asif Mushtaq

13,010
3
33
42

score 2 · Answer 3 · answered Jul 04 '12 at 12:29

2

 DataTable dt = new DataTable();
        dt.Columns.Add();
        dt.Columns.Add();
        dt.Columns.Add();
        List<string> tempList = new List<string>() { "a", "b", "c" };
        dt.Rows.Add(tempList.ToArray<string>());

answered Jul 04 '12 at 12:29

VEDAVYAS BHAT

21
1

Add entire row to DataTable at once using list

3 Answers3

Linked