conversion error

conversion error

Amita Gupta

hi all ,

i am getting error when i am converting dbnull value to integer value .

please help me how to solve this type of error

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Puneet Kankar9y ago
int y = (!reader["PublicationYear"] is DBNull) ? Convert.ToInt32(reader["PublicationYear"]) : 0;

https://stackoverflow.com/questions/9377739/how-to-safely-cast-nullable-result-from-sqlreader-to-int
Rafnas T P9y ago
hi,
like this situation, check value is null before converting, and change this value into 0 and assign to your integer variable
try as follows
int i = 0;
string a= null;//for example your value is a
         if(!int.TryParse(a,out i))
          {
              //assign your 0 value  here
              a = "0";//if a is null then it changes to 0
          }
          //after this you can convert to integer

Rahul9y ago

Do like this. Hope it helps -

int y = (!reader["WhatEverProperty"] is DBNull) ? Convert.ToInt32(reader["WhatEverProperty"]) : 0;