Cloud Training (Online)




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

Senthil Kumar B
Senthil Kumar is a former Microsoft MVP (Most Valuable Professional). He is a Co-Author of the book "Windows 10 Development Recipes using JavaScript and CSS" for Apress Publication. He is a technical presenter, blogger, mentor and a Geek.  Senthil is a regular speaker is various local user groups. He has presented at conferences like Great Indian Developer Summit (GIDS) & Microsoft DevCamps. You can reach out to him via his Twitter handle @isenthil.