SqlDataReader.IsDBNull Method 
I think i need to use this to check for null values prior to using the
statement "address.Value = myReader.GetString(5)" otherwise I get the
error "Data is Null. This method or property cannot be called on Null
values"
but am unsure of the code to use it.Please could you give me an
example of the required code to check for null values prior to using
the getstring method
Thanks

---

Request for Question Clarification by bio-ga on 20 Feb 2003 11:22 PST

Hi,

Can you please clarify what language and what database server are you using?

Thanks
Bio

---

Clarification of Question by homebuilder-ga on 20 Feb 2003 12:31 PST

I am using VB.Net with SQL Server2000 running on Windows 2000 Server.

Dear homebuilder-ga,

You're quite correct in that you need to call this method in order to
check for NULL values before retrieving data through your
SqlDataReader. The specific code you need to do this looks like this:

If (myReader.IsDBNull (5)) Then
  ' Handle a NULL value, in some appropriate way. Here, I just
substitute
  ' an empty string for the NULL.
  address.Value = ""
Else
  ' Retrieve the actual value
  address.Value = myReader.GetString (5)
End If

An example of using a SqlDataReader to read information from a
database, including this code, can be found by going to:

http://samples.gotdotnet.com/quickstart/howto/

then scrolling down to "Data and ADO.NET", and selecting "Retrieve
data from a SQLServer database".

If this answer isn't quite what you're looking for, please feel free
to request a clarification,

cerebrate-ga

Search strategy:

Personal knowledge.