Reading Empty Cells

[haroldjclements]

I have a problem with reading null value from my database. The connection works and does retrieve the data. However if there is an empty cell in the database it creates an exception

 

[haroldjclements]

ok, I have worked it out. Using the try and catch you can tell your program to just ignore that error.

Hope this helps someone.
Harold

 

[samsmithnz]

Try checking to see if the value is null before assigning it to the string. Youll find this alot quicker than catching an exception.

 

[haroldjclements]

Hello, I know it

 

[haroldjclements]

Ok found it:

if (myDataReader.IsDBNull(5)){textBox3.set_Text("");}
else {textBox3.set_Text(myDataReader.GetString(5));}

Cheers,
Harold Clements