C#

while (odbcDataReader.Read())
    {
        string strName = odbcDataReader.GetString(nColNumbernColName);
        int nNumber = odbcDataReader.GetInt32(nColNumber);
    }

__John_ wrote:

@PIEBALDconsult: Yes, I should check the return but it makes no differance to my
question.

var Val = odbcDataReader.GetInt32(nColNumber);

__John_ wrote:

odbcDataReader.IsDBNull(nColNumber);

odbcSelectCommand.CommandText = @"SELECT name, iq FROM Table_People WHERE iq < 3 ORDER BY iq";

int nColName   = odbcDataReader.GetOrdinal(@"name");
    int nColNumber = odbcDataReader.GetOrdinal(@"iq");

    while (odbcDataReader.Read())
    {
        if(odbcDataReader.IsDBNull(nColNumber))
        {
            continue;
        }

        int nNumber = odbcDataReader.GetInt32(nColNumber);

        string strNumber = odbcDataReader.GetString(nColNumber);

    }

     while(dr.Read()){
     string name = dr[0].ToString();
     int iq = (int)dr[1];
}

__John_ wrote:

my way is more robust

MDL=>Moshu wrote:

string name = dr[0].ToString();

int nameColumn = odbcDataReader.GetOrdinal(@"name");
int idColumn = odbcDataReader.GetOrdinal(@"iq");
while (odbcDataReader.Read()){
        odbcDataReader.IsDBNull(idColumn);
        int iqValue= odbcDataReader.GetInt32(idColumn);
        string nameValue = odbcDataReader.GetString(nameColumn );
}