convert data table to string array in c#

Question

I have a data table .I want to convert my data table into string array. data table dt = new data table(); string[] array = dt ; Suggest some ideas ...

Dilip Gupta · Answer

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

Dinesh Santhalingam · Answer

if data table have Multi column then how to add the column to the string arrray @ Dilip Gupta

Dilip Gupta · Answer

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 { userArr[i] = dt.Rows[i][columnIndex].ToString(); } if you want list of string array then reffer static List ConvertTable(DataTable table) { return table.Rows.Cast () .Select(row => table.Columns.Cast () .Select(col => Convert.ToString(row[col])) .ToArray()) .ToList(); }

Dinesh Santhalingam · Answer

Its not working @ Amit Singh. Can you please suggest some C# method to achieve solution.

Amit Kumar Singh · Answer

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.

convert data table to string array in c#

Answers (5)