IsDBNul with string

Question

I try to use

currentOrder.PONumber = (reader.IsDBNull("PONumber") ? "Geen klantreferentie" : reader.GetString("PONumber"));

and I have the following errors:

The best overloaded method match for 'System.Data.Common.DbDataReader.IsDBNull(int)' has some invalid arguments.

and

Argument 1: cannot convert from 'string' to 'int'.

When I use the columnindex in IsDBNull, I have the following error:

Data is Null. This method or property cannot be called on Null values.

How can I solve this?

Can you share the code for when you use the column index, as that's the way the documentation says to use it? — Adrian Wragg, Mar 17 '14 at 13:30
It sounds to me like your currentOrder.PONumber property is an int and you are trying to assign strings to it. — Justin Harvey, Mar 17 '14 at 13:32

score 6 · Accepted Answer · edited Mar 17 '14 at 13:40

6

Use

reader.IsDBNull(reader.GetOrdinal("PONumber"))

Or if you are iterating many rows, keep hold of the ordinal and re-use it:

var poNumberOrdinal = reader.GetOrdinal("PONumber");

while (reader.Read())
{
    reader.IsDBNull(poNumberOrdinal);
}

edited Mar 17 '14 at 13:40

Adam Houldsworth

answered Mar 17 '14 at 13:31

jpw

@AdamHouldsworth I do it only one time. – Marten Mar 17 '14 at 13:41
@MartenB Ok then simply using it as shown will work. – Adam Houldsworth Mar 17 '14 at 13:42

score 1 · Answer 2 · answered Mar 17 '14 at 13:32

1

Try This:

currentOrder.PONumber = reader["PONumber"].Equals(DBNull.Value) ? 
                         "Geen klantreferentie" :  reader.GetString("PONumber"));

answered Mar 17 '14 at 13:32

2 Answers2