datatable field name and field values

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Matt

    datatable field name and field values

    Have sql return 2 rows 2 columns
    Column A Column B
    123 abc
    234 cde
    Cant get the Column names and column values any help?
    do i need to loop objRead or datarow and datacolumn would be ok..
    SqlDataReader objRead = m.DataRead(conn ,sql);
    DataTable myTable = objRead.GetSche maTable();
    while ( objRead.Read() )
    {
    foreach(DataRow myRow in myTable.Rows)
    {
    Console.WriteLi ne(myRow["ColumnName "].ToString());
    foreach(DataCol umn myCol in myTable.Columns )
    {
    Console.WriteLi ne((myRow["ColumnName "]).ToString());
    Console.WriteLi ne("Column values");
    }
    }
    }

Working...