ASP.Net check value with DBNULL

Question

I have the following code

foreach (DataRowView dr in Data)
        {
            if (dr == System.DBNull.Value)
            {
                nedID = 1;
            }
        }

but i get the following error Operator == cannot be applied to operands of type System.Data.DataRowView and System.DBNull

please can some one advice me on how i can check if the value is null or DBNULL

Michael Dean · Accepted Answer · 2010-03-23 16:13:30Z

14

You need to specify the field name or index.

foreach (DataRowView dr in Data)
{
    if (dr["nameOfField"] == System.DBNull.Value)
    {
        nedID = 1;
    }
}

answered Mar 23, 2010 at 16:13

Michael Dean

1,5969 silver badges11 bronze badges

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

Comments

Dead account · Accepted Answer · 2010-03-23 16:13:21Z

6

You need to replace dr == System.DBNull.Value with...

Convert.IsDBNull(dr["somefield"])

which returns true if it's DBNnull

answered Mar 23, 2010 at 16:13

Dead account

20k13 gold badges54 silver badges82 bronze badges

Collectives™ on Stack Overflow

ASP.Net check value with DBNULL

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related