Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to get list of one column values from DataTable?

I have DataTable.

DataTable dt = new DataTable();  dt.Columns.Add(new DataColumn("id", Type.GetType("System.Int32"))); dt.Columns.Add(new DataColumn("name", Type.GetType("System.String"))); // more columns here 

I need list of "id" values.

Can I do it without loop over all rows in my DataTable and without Linq?

Edit:

After small discussion with Sergei I decided to use loop anyway.

like image 350
Kamil Avatar asked May 19 '14 10:05

Kamil


People also ask

How to get one column values from DataTable in c#?

Add((int)row["id"]); Note for efficiency it's better to use row[index] instead of row[columnName] . First one just gets column by index from columns array. Latter gets column index from internal dictionary which maps names to indexes, and only then gets column by index.

What activity is used to get a column value from a specific row of a DataTable?

ColumnIndex - The index of the column whose value is to be retrieved from the DataRow. ColumnName - The name of the column whose value is to be retrieved from the DataRow.


1 Answers

You can use Linq to DataTable:

var ids = dt.AsEnumerable().Select(r => r.Field<int>("id")).ToList(); 

UPDATE: Without Linq

List<int> ids = new List<int>(dt.Rows.Count); foreach(DataRow row in dt.Rows)     ids.Add((int)row["id"]); 

Note for efficiency it's better to use row[index] instead of row[columnName]. First one just gets column by index from columns array. Latter gets column index from internal dictionary which maps names to indexes, and only then gets column by index.

Another thing to note is initializing list's capacity with rows count. If you will not do this, then internal array of list will be re-created and copied many times (depends on rows count).

And last thing to say - most efficient way with huge table (if possible) is filtering data on server side.

like image 108
Sergey Berezovskiy Avatar answered Sep 24 '22 10:09

Sergey Berezovskiy