how to handle null values

[psycho]

how should i hanle null values returned by the datareader
i am using OleDbDataReader for accessing access database.

 

[Eliyahu Goldin]

Typically you would first check if the value is null with IsDbNull method.
If it is not, you can get the value with one of the GetXxx methods

 

[Patrick.O.Ige]

use IsDBNull.value
Patrick

 

[Karl Seguin [MVP]]

There's a SafeDataReader in the CSLA.NET which takes care of this for you.

Here's the VB.NET version:
http://www.lhotka.net/Article.aspx?id=9280bc86-c706-4d2d-8993-8b5bda6bad22

there's a C# one somewhere on the site...

Karl