Error when checking if SqlDataReader column has null value

Question

One of the guys working on a project with me keeps getting an error when the code trys to validate if SqlDataReader returns a null value in a column. He runs this code:

if (!DB_Conn.isConnected()) DB_Conn.Connect();
using (SqlDataReader dr = DB_Conn.QueryDB(query))
{
   if (dr.HasRows && !dr.IsDBNull(0))
   {
       maxID = dr.GetInt32(0);
   }
}

But gets an error that Its an invalid attemtp to read when no data is present at the !dr.IsDBNull(0) command.

If i run this same code but i query a different table, it works.

Also, i run both queries and they return the expected null value. The querys are:

SELECT MAX(ID) FROM Loan;
SELECT MAX(ID) FROM InternationalSwap;

I dont think the querys have any affect on the reason why we are getting this error at one machine and not the other.

LukeH · Accepted Answer · 2012-02-16 17:07:42Z

5

You need to call the Read method before trying to access any columns:

while (dr.Read())
{
    if (!dr.IsDBNull(0))
        maxID = dr.GetInt32(0);
}

But... if you only need a single value then you should probably use something like ExecuteScalar rather than a datareader.

answered Feb 16, 2012 at 17:07

LukeH

271k59 gold badges373 silver badges411 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

DFord Over a year ago

This works, but i'm a little confused as to why it worked with me, but then i didn't work at my coworkers computer with practically the same code. Anyway, thanks for the help.

Collectives™ on Stack Overflow

Error when checking if SqlDataReader column has null value

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related