Checking if a record in datareader is NULL

Question

I have browsed thru other postings on S/O, but I can't find a solution that works for me.

I have a datareader that might return a null value, and if so, I want to value to equal blank

txtMiddleName.Text = rdrGetUserInfo.GetString(1) ?? "";

The string above does not work. When I walk thru the code, the code jumps to my error trapping block;

Any ideas?

@user279521 - You will want to check IsDBNull before you call getstring. Otherwise you'll get a null exception thrown. See my answer below: txtMiddleName.Text = rdrGetUserInfo.IsDBNull(1) ? String.Empty : rdrGetUserInfo.GetString(1); — JonH
– JonH, Commented Mar 22, 2010 at 14:57

Musakkhir Sayyed · Accepted Answer · 2016-01-15 13:58:35Z

7

Try

txtMiddleName.Text = rdrGetUserInfo.IsDBNull(1) ? string.Empty : rdrGetUserInfo.GetString(1);

edited Jan 15, 2016 at 13:58

Musakkhir Sayyed

7,21813 gold badges44 silver badges67 bronze badges

answered Mar 22, 2010 at 14:51

Mark

861 bronze badge

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

1 Comment

JonH Over a year ago

Is it me or does anyone else hate "", use String.Empty its cleaner. More .net.

Andy Shellam · Accepted Answer · 2010-03-22 14:51:18Z

2

You can use the IsDBNull method on the DataReader.

if (!rdrGetUserInfo.IsDBNull(1))
{
    txtMiddleName.Text = rdrGetUserInfo.GetString(1);
}

answered Mar 22, 2010 at 14:51

Andy Shellam

15.6k1 gold badge29 silver badges41 bronze badges

Comments

Fermin · Accepted Answer · 2010-03-22 14:50:49Z

1

It's because the rdrGetUserInfo is returning DBNull which is a class.

Before getting the string do a check for dbnull it's something like (been a while since I used one!):

if (!rdrGetUserInfo.IsDBNull("someField"))
 txtMiddleName.Text = rdrGetUserInfo.GetString(1);

answered Mar 22, 2010 at 14:50

Fermin

36.3k22 gold badges87 silver badges131 bronze badges

Comments

JonH · Accepted Answer · 2010-03-22 14:52:10Z

1

If(rdr("Field") == DBNull.Value) 
  'assign String.Empty 
myString = string.Empty;
else
  'assign value
   myString = rdr("Field");

Or to shorten this up you could do this:

txtMiddleName.Text = rdrGetUserInfo.IsDBNull(1) ? String.Empty : rdrGetUserInfo.GetString(1);

answered Mar 22, 2010 at 14:52

JonH

33.2k13 gold badges94 silver badges149 bronze badges

Comments

Klaus Byskov Pedersen · Accepted Answer · 2010-03-22 14:51:10Z

0

You should check the column for DbNull before calling GetString.

answered Mar 22, 2010 at 14:51

Klaus Byskov Pedersen

122k31 gold badges192 silver badges222 bronze badges

Comments

ZXX · Accepted Answer · 2010-07-24 01:52:53Z

IsDbNull(int) is usually much slower that using methods like GetSqlInt32 and then comparing to DBNull.Value or using it's own .IsNull Like:

    public static int Int32(this SqlDataReader r, int ord)
    {
        var t = r.GetSqlInt32(ord);
        return t.IsNull ? default(int) : t.Value;
    }

Tried a few template solutions but to no avail so far. The problem is that all Sql-types (SqlInt32 here) types are actually structs and while they all have .Value property C# doesn't have real templates to handle that. Also they have their own INullable interface which has only .IsNull and is not conpatible with Nyllable<>.

I suspect that one would need full set of Sql-types as C# templates or to add ICOnvertible to them in order to be able to have just one or two templated methods.

If someone has maybe an idea with a functional trick or two speak up :-)

Collectives™ on Stack Overflow

Checking if a record in datareader is NULL

6 Answers 6

1 Comment

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

6 Answers 6

1 Comment

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related