1/// <summary>

2/// Gets if a sql datareader contains a column from a column-name.

3/// </summary>

4/// <param name="reader"></param>

5/// <param name="columnName">The name of the column.</param>

6/// <returns>True if the reader contains the column; otherwise false.</returns>

7protected bool DataReaderColumnExists(System.Data.SqlClient.SqlDataReader reader, string columnName)
8{
9    if (reader == null)
10    {
11        return false;
12    }
13
14    string filter = string.Format("ColumnName='{0}'", columnName);
15    System.Data.DataView dataView = reader.GetSchemaTable().DefaultView;
16    dataView.RowFilter = filter;
17
18    return dataView.Count > 0 ? true : false;
19}