Retrieving Column Name And Value For Each Row Using GetSchemaTable

I know I can iterate through the schema table using the following.



Can I grab the actual value of each field while looping through the rows and columns?



schemaTable = reader.GetSchemaTable();

foreach (DataRow myDataRow in schemaTable.Rows)

{


foreach (DataColumn myDataColumn in schemaTable.Columns)

{




Console.WriteLine(myDataColumn + "= " + myDataRow[myDataColumn.ColumnName].ToString() );
}

}





An example is if one of the columns in the schema is called Firstname I would like to return:



Row 1

column name = Firstname

value= Bob

column name = Lastname

value= Smith



Row 2

column name = Firstname

value= Greg

column name = Lastname

value= Jones