How to check for the column name in an SqlDataReader Object in C# ?

When working in ADO.NET for data access , there are times when you want to check to see if a column exists in a SqlDataReader object. You can easily find out if the column exists in the SqlDataReader object as shown in the code snippet.

How to check for the column name in an SqlDataReader Object in C# ?

public static bool IsColumnExists(SqlDataReader dataReader, string columnName)
{
    for (int i = 0; i < dataReader.FieldCount; i++)
    {
        if (dataReader.GetName(i).Equals(columnName))
            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 Reply