How to determine if dataset is empty?

[ccbryan]

Hi folks... .NET newbie I admit. I'm running VS 2005 version 8 on .NET platform 2.0.50727 SP1. How can you tell if a query has returned an empty dataset to a SQLReader or a DataTable? I am running this code...

Dim cnnNav3 As SqlConnection = New SqlConnection("Data Source _
& =(local);initial catalog=NAVSQL;Integrated Security = SSPI")
cnnNav3.Open()
Dim strYarn As String
strYarn = cy(j, 0) 'from a previous array
Dim cmdYarnPrice As SqlCommand = cnnNav3.CreateCommand
cmdYarnPrice.CommandType = CommandType.Text
cmdYarnPrice.CommandText = "Select [Standard Cost] from" _
& "Item where [Item No.] = '" & strItem & "'"
Dim daYarnPrice As SqlDataAdapter = New SqlDataAdapter()
daYarnPrice.SelectCommand = cmdYarnPrice
daYarnPrice.Fill(ds, "Item")
Dim dtYarnPrice As DataTable
dtYarnPrice = ds.Tables("Item")

Up to this point the code seems to run fine, but if I try to say..

if dtYarnPrice.rows.count > 0

I get an error. Debug tells me that dtYarnPrice equals Nothing, so evidently no records were returned, but .NET rejects any expressions like...

if dtYarnPrice = Nothing then

So how do I determine whether my query returned any rows?? Thanks in advance for your time...


Chandler

[dip_developer]

Hi folks... .NET newbie I admit. I'm running VS 2005 version 8 on .NET platform 2.0.50727 SP1. How can you tell if a query has returned an empty dataset to a SQLReader or a DataTable? I am running this code...

Dim cnnNav3 As SqlConnection = New SqlConnection("Data Source _

& =(local);initial catalog=NAVSQL;Integrated Security = SSPI")
cnnNav3.Open()
Dim strYarn As String
strYarn = cy(j, 0) 'from a previous array
Dim cmdYarnPrice As SqlCommand = cnnNav3.CreateCommand
cmdYarnPrice.CommandType = CommandType.Text
cmdYarnPrice.CommandText = "Select [Standard Cost] from" _
& "Item where [Item No.] = '" & strItem & "'"
Dim daYarnPrice As SqlDataAdapter = New SqlDataAdapter()
daYarnPrice.SelectCommand = cmdYarnPrice
daYarnPrice.Fill(ds, "Item")
Dim dtYarnPrice As DataTable
dtYarnPrice = ds.Tables("Item")

Up to this point the code seems to run fine, but if I try to say..

if dtYarnPrice.rows.count > 0

I get an error. Debug tells me that dtYarnPrice equals Nothing, so evidently no records were returned, but .NET rejects any expressions like...

if dtYarnPrice = Nothing then

So how do I determine whether my query returned any rows?? Thanks in advance for your time...


Chandler

try............ ds.Tables[0].Rows.Count

[ccbryan]

try............ ds.Tables[0].Rows.Count

Thank you! That did the trick, and I even see how it works.

Chandler