Loading

DataTable to array

Hello

How to convert DataTable to string array?

there are only one column in datatable.

Thank in advance.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Abhishek Kumar12y ago
Hi,
DataTable dt=new DataTable ();
string[] array = dt
                 .AsEnumerable()
                 .Select(row => row.Field("db_Column"))
                 .ToArray();

Hope this will work.

Thanks.
Vulpes12y ago
If 'dt' is your datatable:

string[] array = (from DataRow dr in dt.Rows select dr[0].ToString()).ToArray();