OleDbDataReader throws NullReferenceException

Asked Feb 24 '15 at 15:24

Active Feb 24 '15 at 15:25

Viewed 17 times

I want to read a single line out of my database with a special number. If i want to write this line in some textboxes, i get a NullReferenceException error. The line is definetly filled in my database.

cmd = new OleDbCommand("select Kundennummer, Kundenname, Firmenbuchnummer, Email, Telefon1, Telefon2, Fax, Website, UID, IBAN, BIC, Strasse, PLZ, Ort, Land, Notizen from tbl_Kunden where Kundennummer = @knr", con);
cmd.Parameters.Add("@knr", OleDbType.Integer, 10);
cmd.Parameters["@knr"].Value = knr;
OleDbDataReader rdr = cmd.ExecuteReader();

while (rdr.Read())
{
    txtNr.Text = rdr[0].ToString();....

edited Feb 24 '15 at 15:25

Habib

205,061
27
376
407

asked Feb 24 '15 at 15:24

Michael Jordan

`rdr[0]` is null for at least one of your records. – D Stanley Feb 24 '15 at 15:37
Filled all null values, but it is still not working.. – Michael Jordan Feb 24 '15 at 15:47
Have you run it in the debugger to be certain? – D Stanley Feb 24 '15 at 15:52
Where can i find the value of rdr[0]? – Michael Jordan Feb 24 '15 at 15:55

OleDbDataReader throws NullReferenceException

0 Answers0