Null data issue

Question

User-937748457 posted

Hi all,

i have a field in class as below

 public int remDays { get; set; }

this get the number of days (days difference betweeen two dates)......start and end date may be null in database.

when this return null then i m getting exception here(Cannot cast DBNull.Value to type 'System.Int32'. Please use a nullable type)

 var query = from o in dsResult.Tables[0].AsEnumerable()
                            select new ban
                            {
                               
                                remDays = o.Field<int>("remDays")


                            };
                List<ban> lstDisplay = new List<ban>();
                lstDisplay.AddRange(query);

Answer 1

User191633014 posted

use :

public int? remDays { get; set; }

and get the value with:

remDays.Value

 

Answer 2

User1283497924 posted

Hi try this

public int? remDays { get; set; }

after tis assign value in below way

remDays = (int)o.Field<int>("remDays") 

Answer 3

User1283497924 posted

Hi try this

public int? remDays { get; set; }

after this assign value in below way

remDays = (int)o.Field<int>("remDays") 

Answer 4

User-937748457 posted

public int? remDays { get; set; }

this give me this error

Cannot cast DBNull.Value to type 'System.Int32'. Please use a nullable type...

i am sure that i have null in table and it return me null(wehn i run query in sqlserver)