SqlDataReader Get Value By Column Name (Not Ordinal Number)

c# sqldatareader
user9927 picture user9927 · Feb 4, 2015 · Viewed 60k times · Source

Using the methods of the SqlDataReader, I can get the value of a column by passing in it's ordinal, such as the value of the first column if I pass in read.GetValue(0), or the second column if I pass in read.GetValue(1).

In looking at the methods, I don't see an option to get the value of a column by passing in the name of a column, such as ColumnID. In my mythical example, I would want to pass in read.GetValueofColumn("ColumnID") and read the value in the column (note that the method GetValueofColumn doesn't exist so far as I can tell from the method list).

Am I missing the method to do this, or a way to do this?

Answer

MatthewG picture MatthewG · Feb 4, 2015

You can get the ordinal of the column by using the GetOrdinal method, so your call could be:

read.GetValue(read.GetOrdinal("ColumnID"));

Related questions

Read data from SqlDataReader

I have a SQL Server 2008 database and I am working on it in the backend. I am working on asp.net/C# SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { //how do I read strings here???? } I know that the reader …

Read More
SQL Data Reader - handling Null column values

I'm using a SQLdatareader to build POCOs from a database. The code works except when it encounters a null value in the database. For example, if the FirstName column in the database contains a null value, an exception is thrown. …

Read More
How to get number of rows using SqlDataReader in C#

My question is how to get the number of rows returned by a query using SqlDataReader in C#. I've seen some answers about this but none were clearly defined except for one that states to do a while loop with …

Read More