How to print all columns in a datareader

c# ado.net datareader
svon picture svon · Apr 29, 2010 · Viewed 19.3k times · Source

Using c# how do I print all columns in a datareader.

Answer

D'Arcy Rittich picture D'Arcy Rittich · Apr 29, 2010

This method will return an enumerable list of column names when passed a datareader:

static List<string> GetDataReaderColumnNames(IDataReader rdr)
{
    var columnNames = new List<string>();
    for (int i = 0; i < rdr.FieldCount; i++)
        columnNames.Add(rdr.GetName(i));
    return columnNames;
}

Related questions

How to fill Dataset with multiple tables?

I'm trying to fill DataSet which contains 2 tables with one to many relationship. I'm using DataReader to achieve this : public DataSet SelectOne(int id) { DataSet result = new DataSet(); using (DbCommand command = Connection.CreateCommand()) { command.CommandText = "select * from table1"; var param = …

Read More
Reading a date using DataReader

I read a string using this format with a data reader. How can I read in a date using similar format? while (MyReader.Read()) { TextBox1.Text = (string)MyReader["Note"]; }

Read More
Enforce only single row returned from DataReader

I seem to write this quite a lot in my code: using (var reader = cmd.ExecuteReader()) { if (reader.Read()) { result = new User((int)reader["UserId"], reader["UserName"].ToString()); } if (reader.Read()) { throw new DataException("multiple rows returned from query"); } } Is …

Read More