'System.Data.Common.DbDataReader.IsDBNull(int)' has some invalid arguments

Question

I'm trying to handle null values coming from a database column (which has either int or null)

I wrote this code :

int? nullInt = null; 
int? typeTwo = myReader.IsDBNull(myReader["Type2"]) ? nullInt : (int)myReader["Type2"];

But I get this error :

The best overloaded method match for 'System.Data.Common.DbDataReader.IsDBNull(int)' has some invalid arguments Can you tell me how to fix this? Thanks.

Soner Gönül · Accepted Answer · 2015-07-06 10:59:45Z

1

Looks like IsDBNull accepts ìnt as a parameter. You can get the number of your Type2 column with GetOrdinal method like;

myReader.IsDBNull(myReader.GetOrdinal("Type2"))

answered Jul 6, 2015 at 10:59

Soner Gönül

99.1k103 gold badges224 silver badges375 bronze badges

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

Collectives™ on Stack Overflow

'System.Data.Common.DbDataReader.IsDBNull(int)' has some invalid arguments

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related