odbc.dll system.nullreferenceexception

[Mertli Ozgur Nevres]

Hi i am using an OdbcDataReader. But i can't read the fields, except the 0. field. I get "system.nullreferenceexception". my code is like below: this is working: MessageBox.Show( objOdbcDR.GetInt32(0).ToString() ); this is throwing the exception: MessageBox.Show( objOdbcDR.GetString(1) ); does anyone know why? thanks. Ozgur Nevres

[Heath Stewart]

Does your SQL query select more than one column?

-----BEGIN GEEK CODE BLOCK----- Version: 3.21 GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++ -----END GEEK CODE BLOCK-----

[Mertli Ozgur Nevres]

yes, 8 columns

[Heath Stewart]

You did call OdbcDataReader.Read before making any calls, didn't you? BTW, it's hard to know what to ask to diagnose the problem because you gave very little information. Perhaps some surrounding code (from getting the OdbcDataReader to closing it) would be more helpful. The problem is most likely not with the immediate statement that throws an exception.

-----BEGIN GEEK CODE BLOCK----- Version: 3.21 GCS/G/MU d- s: a- C++++ UL@ P++(+++) L+(--) E--- W+++ N++ o+ K? w++++ O- M(+) V? PS-- PE Y++ PGP++ t++@ 5 X+++ R+@ tv+ b(-)>b++ DI++++ D+ G e++>+++ h---* r+++ y+++ -----END GEEK CODE BLOCK-----