converting the value of the data reader to a nullable variable

advertisements

I'm trying to run the following code but get a casting error. How can I rewrite my code to achive the same ?

boolResult= (bool?)dataReader["BOOL_FLAG"] ?? true;
intResult= (int?)dataReader["INT_VALUE"] ?? 0;

Thanks

Use the "IsDbNull" method on the data reader... for example:

bool? result = dataReader.IsDbNull(dataReader["Bool_Flag"]) ? null : (bool)dataReader["Bool_Flag"]

Edit

You'd need to do something akin to: bool? nullBoolean = null;

you'd have

bool? result = dataReader.IsDbNull(dataReader["Bool_Flag"]) ? nullBoolean : (bool)dataReader["Bool_Flag"]

Related Articles

convert the date value to mysql in age

I have a table in the databse named myTable and inside the table there is a row named myBirth , I inserted inside mybirth row date value which is stored as a DATETIME. and I want to know how to convert the date value in mysql into age and then echo i

Convert the date format M / d / yyyy to MM / dd / yyyy in c #

I am trying to convert the date which is in format 4/3/1950 12:00:00 AM I am getting the value of date from sql data reader string dob =Convert.ToString(MbrNameReader[2]); the output of dob string is 4/3/1950 12:00:00 AM Now I would like to convert t

Convert the date of the Persian to Gregorian Date

To convert a string Persian date to gregorian DateTime, I use date time picker and it sends me a string like "۱۳۹۴/۰۲/۲۰" PersianCalendar p = new PersianCalendar(); string[] d = start.Split('/'); DateTime dt = new DateTime(int.Parse(d[0]), int.P

Converting the Date to String object

I have use the following code snippet to convert the Date object to string . var startDate = new Date(); var result = Globalize.parseDate(startDate, "MM/DD/YYYY"); but it will return the null value. How to convert the Date object to string speci

How to convert the date string to the time zone in NSDate

How to convert the Date String "2012-05-03 06:03:00 +0000" to NSDate. I user the code below, but it does not work: NSDateFormatter *datFormatter = [[NSDateFormatter alloc] init]; [datFormatter setDateFormat:@"yyyy-MM-dd HH:mm:ss Z"]; N

SQL command without filling in the data reader

I am working on a nested repeater. My issue seems to be at the moment, that when I execute my SQL command that no data is returned to the data reader. Even when I run the exact same query (Copy and Pasted) into SQL Server. My noteDrClient reader does

The sql server converts the date to a MM / DD / YYYY chain

I am using SQL Server 2008. I have the following: select convert(varchar(20),fmdate) from Sery How do I convert the date to string such that it show as MM/DD/YYYYThat task should be done by the next layer up in your software stack. SQL is a data repo