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");
}
}
}
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");
}
}
}