One columned datatable to List

Question

I have a datatable which contains only one column and all items are strings. How can I convert this to a List<string> using LINQ for example?

I Tried:

DataRow[] rows = dtusers.Select();
var qq = from RowCollection in rows
         select new { UserCode = LibStatic.ToStr(RowCollection["UserCode"]) };

List<string> users = new List<string>();
users = qq.Cast<string>().ToList();

There is the easyway which always works:

foreach (DataRow dr in dtusers.Rows)
{
    users.Add(dr[0].ToString());
}

score 91 · Accepted Answer · answered Feb 28 '13 at 07:23

91

You can use LINQ query to do that.

List<string> list = dtusers.AsEnumerable()
                           .Select(r=> r.Field<string>("UserCode"))
                           .ToList();

answered Feb 28 '13 at 07:23

Habib

219,104
29
407
436

10

thanks, For anyone wanna avoid column name use .Select(r => r.Field(0)) – Imran Qadir Baksh - Baloch Feb 14 '18 at 07:25
4

i got an error EnumerableRowCollection does not contain definition for List.. in this case import System.LinQ package to your class – Avdhut Vaidya Feb 25 '18 at 09:08

score 5 · Answer 2 · answered Apr 24 '19 at 08:25

5

You can try this code,

List<string> list = dt.Rows.OfType<DataRow>().Select(dr => (string)dr["ColumnName"]).ToList();

answered Apr 24 '19 at 08:25

Nitika Chopra

1,281
17
22

One columned datatable to List

2 Answers2

Linked

Related