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

Your 2020 Plan. Learn 20 minutes a day for 20 days. Online courses from €9.99.

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;
}

Leave a Reply

Your email address will not be published. Required fields are marked *