C#: How to get the all the field/column names in a DataReader
The following helper method writes out the index position, the name and the data type for all the fields/columns in a DataReader, to the output window in Visual Studio:
public static void DataReaderDebugger(IDataReader reader)
{
System.Diagnostics.Debug.WriteLine("### DataReader Debug Info ###");
for (int i = 0; i < reader.FieldCount; i++)
{
string info = string.Format("{0}. {1} ({2})",
i.ToString(),
reader.GetName(i),
reader.GetFieldType(i).Name);
System.Diagnostics.Debug.WriteLine(info);
}
System.Diagnostics.Debug.WriteLine("######");
}
Published: 21.08.2011
blog comments powered by Disqus

