How to Convert the value in DataTable into a string array in c

Question

I have a DataTable that contains a single row  I want to convert this DataTable values into a string array such that i can access the column values of that DataTable through the string array index For example  if my DataTable is as follows     Name     Address      Age    -------------------------------    jim        USA        23       I want to store the values in that Datatable into my string array such that MyStringArray 1  will give me the value USA   Thanks in  Advance

User · Answer

string   result   new string table Columns Count               DataRow dr   table Rows 0               for  int i   0  i  lt  dr ItemArray Length  i                                  result i    dr i  ToString                              foreach  string str in result                  Console WriteLine str

User · Answer

Perhaps something like this  assuming that there are many of these rows inside of the datatable and that each row is row   List lt string   gt  MyStringArrays   new List lt string   gt     foreach  var row in datatable rows    or similar    MyStringArrays Add  new string   row Name row Address row Age ToString           You could then access one   MyStringArrays ElementAt 0  1    If you use linqpad  here is a very simple scenario of your example   class Datatable    public List lt data gt  rows   get  set     public Datatable      rows   new List lt data gt           class data    public string Name   get  set     public string Address   get  set     public int Age   get  set       void Main      var datatable   new Datatable     var r   new data     r Name    Jim    r Address    USA    r Age   23   datatable rows Add r    List lt string   gt  MyStringArrays   new List lt string   gt      foreach  var row in datatable rows    or similar      MyStringArrays Add  new string   row Name row Address row Age ToString           var s   MyStringArrays ElementAt 0  1    Console Write s     USA

User · Answer

private string   GetPrimaryKeysofTable string TableName                string stsqlCommand    SELECT column name FROM INFORMATION SCHEMA KEY COLUMN USAGE                                    WHERE OBJECTPROPERTY OBJECT ID constraint name    IsPrimaryKey     1                                   AND table name       TableName               SqlCommand command   new SqlCommand stsqlCommand  Connection           SqlDataAdapter adapter   new SqlDataAdapter            adapter SelectCommand   command           DataTable table   new DataTable            table Locale   System Globalization CultureInfo InvariantCulture           adapter Fill table            string   result   new string table Rows Count           int i   0          foreach  DataRow dr in table Rows                        result i      dr 0  ToString                       return result

User · Answer

Very easy   var stringArr   dataTable Rows 0  ItemArray Select x   gt  x ToString    ToArray      Where DataRow ItemArray property is an array of objects containing the values of the row for each columns of the data table

User · Answer

If you would like to use System Data instead of System LINQ  then you can do something like this   List lt string gt  BrandsInDataTable   new List lt string gt      DataTable g   Access  ME G BrandsInPop             if  g Rows Count  gt  0                        for  int x   0  x  lt  g Rows Count  x                    BrandsInDataTable Add g Rows x   quot Name quot   ToString                        else return

User · Answer

If that s all what you want to do  you don t need to convert it into an array  You can just access it as   string myData yourDataTable Rows 0  1  ToString     Gives you USA

[c#] How to Convert the value in DataTable into a string array in c#

Examples related to c#

Examples related to .net

Examples related to linq