Can you get the column names from a SqlDataReader?

c# ado.net sqldatareader
Blankman picture Blankman · Mar 25, 2009 · Viewed 237.8k times · Source

After connecting to the database, can I get the name of all the columns that were returned in my SqlDataReader?

Answer

Rob Stevenson-Leggett picture Rob Stevenson-Leggett · Mar 25, 2009 
var reader = cmd.ExecuteReader();

var columns = new List<string>();

for(int i=0;i<reader.FieldCount;i++)
{
   columns.Add(reader.GetName(i));
}

or 

var columns = Enumerable.Range(0, reader.FieldCount).Select(reader.GetName).ToList();

Related questions

Is there anything faster than SqlDataReader in .NET?

I need to load one column of strings from table on SqlServer into Array in memory using C#. Is there a faster way than open SqlDataReader and loop through it. Table is large and time is critical. EDIT I am …

Read More
SqlDataReader Best way to check for null values -sqlDataReader.IsDBNull vs DBNull.Value

I want to retrieve decimal values from the database and I would like to know which is the recommended way to check for null values. I have seen on MSDN - DBNull.Value Field that this check is rarely used. …

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