Checking Data Adapter [Resolved]

Evening All,

I set my data adapter like this:

da.SelectCommand = ....etc

I then fill a data table with it.

Everything is working just find in my app, but I have the need to check the da before I do the fill, in the event the select found no results and is empty, and handle it accordingly.

Right now it's jut bombing on the fill because the select is returning nothing. Would like to check with a simple if statement if possible.

Dim iCount As Integer

iCount = da.Fill(ds.dt)

If iCount = 0 Then
....
Else
...
endIf

That didn't work.

I just ended up using an exception catch for this. Thanks for the help.