Testing a DataSet for Null values

[Joe]

I am using a Visual Basic parametized query to locate a
record in a SQL Server per the following code:

daRER.SelectCommand.Parameters("@My_RER").Value = My_RER
daRER.Fill(dsRER)

How would I test the dataset to ensure that a Null record
was not delieved to the dsRER DataSet. @My_RER is
connected to the PrimaryKey of a SQL Table. This test
will determine if a message box will be displayed to the
user to enter another RER Number.

Thanks

 

[Teemu Keiski]

SqlDataAdapter's Fill method returns the count of added of refreshed rows in
the DataTable.

--
Teemu Keiski
MCP,Designer/Developer
Mansoft tietotekniikka Oy
http://www.mansoft.fi

ASP.NET Forums Moderator, www.asp.net
AspAlliance Columnist, www.aspalliance.com

Email:
(e-mail address removed)

 

[Steven Bras [MS]]

Excellent alternative, Teemu. Thanks!

Steven Bras, MCSD
Microsoft Developer Support/Visual Basic WebData

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.