convert data table to string array in c#

please reffer follwing link

 

http://stackoverflow.com/questions/2077592/best-practice-when-converting-datacolumn-values-to-an-array-of-strings 

Dilip Gupta

How many column in datatable?

 

if you have single column

 reffer this

int columnIndex = 0; //single-column DataTable
string[] userArr = new string[dt.Rows.Count];
for( int i = 0; i < dt.Rows.Count; i++)
{
userArr[i] = dt.Rows[i][columnIndex].ToString();
} 

 

if you want list of string array then

reffer

 

Can you please suggest some C# method to achieve solution.

hey

 

Try this (LINQ method syntax):

string[] columnNames = dt.Columns.Cast<DataColumn>() .Select(x => x.ColumnName) .ToArray(); 

or in LINQ Query syntax:

string[] columnNames = (from dc in dt.Columns.Cast<DataColumn>() select dc.ColumnName).ToArray();

Cast is required, because Columns is of type DataColumnCollection which is a IEnumerable, not IEnumerable. The other parts should be obvious.