How to Check for Column Name in SqlDataReader object in C# ?

Published on February 10, 2016 by abundantcode

Filed under ADO.NET

Last modified February 9, 2016

Print this page

rate 1 star rate 2 star rate 3 star rate 4 star rate 5 star
Your rating: none, Average: 0 (0 votes)

This article have been viewed 1504 times

Do you want to check if a column exists in a SqlDataReader instance in C# ?. One of the simplest solution is to navigate to all the fields within the data reader and check the name of the field using the GetName method as shown below.

How to Check for Column Name in SqlDataReader object in C# ?

public static bool HasColumn(IDataRecord dataReader, string columnName)
    for (int i = 0; i < dataReader.FieldCount; i++)
        if (dataReader.GetName(i).Equals(columnName, StringComparison.InvariantCultureIgnoreCase))
            return true;
    return false;
If you enjoyed this post, please consider leaving a comment or subscribing to the RSS feed to have future articles delivered to your feed reader.

Leave a Comment


You might be Interested in these Posts

How to Get the number of elements in ArrayList in C# ?

Here's the code that demonstrates how one can get the total number of elements contained in the Arra...

How to Check if the ArrayList is read-only in C# ?

There are times when you would use the read-only wrapper in order to prevent modifying the ArrayList...

How to Add range of elements to ArrayList in C# ?

You can use the AddRange method of the ArrayList object to add the range of elements (string array) ...