-
Empty Dataset
How can I check whether the retreived dataset is empty? I've tried to do it with the code below but it generates an error
Regards,
John
DsProfile1.Clear()
OleDbDataAdapter1.Fill(DsProfile1)
Dim iCnt As Integer
iCnt = Me.BindingContext(DsProfile1, "profileid").Count
if icnt = 0 etc etc
-
Resolved
Not sure whether anyone is interested! The answer is below:
DsProfile1.Clear()
OleDbDataAdapter1.Fill(DsProfile1, "Combined")
Dim iCnt As Integer
iCnt = DsProfile1.Tables("Combined").Rows.Count