Re: NullReferenceException when connection to ASP.NET website

[Tobin Cataldo]

You are using ODBCDataReader incorrectly (http://msdn.microsoft.com/en-us/library/system.data.odbc.odbcdatareader_methods.aspx). Columns are referenced via ordinal not name.

while (dr.Read())
{
 int intID = dr.GetInt32(0);
 string strName = dr.GetString(1);
}

Alternatively you can load a DataTable via OdbcDataAdapter. You can reference columns by name from the DataTable.

  command.CommandText = _sql;
  OdbcDataAdapter _adapter = new OdbcDataAdapter(command);
  System.Data.DataTable _dataTable = new System.Data.DataTable();
  _adapter.Fill(_dataTable);

 if (_dataTable.Rows.Count > 0)
 {
   foreach (System.Data.DataRow _dr in _dataTable) 
   {
          string id = _dr["ID"].ToString();
          string name = _dr["Name"].ToString();
   }            
 }

DataRow : http://msdn.microsoft.com/en-us/library/system.data.datarow.aspx