checking for 0 records in a table

[DC Gringo]

How can I check for the number of records in a table?

If MyDataSet1.Table1.recordcount = 0
'my code'
End If

 

[Hermit Dave]

MyDataSet1.Tables[0].Rows.Count

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)

 

[Mark Fitzpatrick]

MyDataSet1.Table1.Rows.Count

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

 

[Davide Vernole [MVP]]

How can I check for the number of records in a table?

If MyDataSet1.Table1.recordcount = 0
'my code'
End If

Try this:

If MyDataSet1.Tables("Table1").Rows.Count = 0 Then
'your code here
End If

 

[Shiva]

Use DataTable.Rows.Count property.

How can I check for the number of records in a table?

If MyDataSet1.Table1.recordcount = 0
'my code'
End If