conversion error

Question

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

Puneet Kankar · Answer

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 P · Answer

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

Rahul Saraswat · Answer

Do like this. Hope it helps - int y = (! reader [ WhatEverProperty ] is DBNull ) ? Convert . ToInt32 ( reader [  WhatEverProperty  ]) : 0 ;