Datareaders crashing on null values

[Guest]

SqlDataReader reader = command.ExecuteReader()
reader.Read()
Name.Value =(string)reader.GetString(1)

if this value is null it crashes, is there a way to determine if the value is null , or can the exception be handled or ignored??

 

[Guest]

Use if(!reader.IsDBNull(1)

then process your SName.Value = (string)....ect

 

[William Ryan eMVP]

You can use the IsDbNull method like DBGod mentions which is what I'd
recommend. You can catch anything though, but in this instance, it's
Definitely not going to be efficient to throw a bunch of exceptions and just
eat them. You can also use IsNull on the SQL Side to supply a default value
if it's null, may or may not be advisable depending on your situation.

HTH,

Bill

--
W.G. Ryan MVP Windows - Embedded

http://forums.devbuzz.com
http://www.knowdotnet.com/dataaccess.html
http://www.msmvps.com/williamryan/

SqlDataReader reader = command.ExecuteReader();
reader.Read();
Name.Value =(string)reader.GetString(1);

if this value is null it crashes, is there a way to determine if the value

is null , or can the exception be handled or ignored??