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

--
_____
DC G

[Hermit Dave]

MyDataSet1.Tables[0].Rows.Count

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"DC Gringo" <dc******@visiontechnology.net> wrote in message
news:ez**************@TK2MSFTNGP09.phx.gbl...

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

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

--
_____
DC G

[Mark Fitzpatrick]

MyDataSet1.Table1.Rows.Count

Hope this helps,
Mark Fitzpatrick
Microsoft MVP - FrontPage

"DC Gringo" <dc******@visiontechnology.net> wrote in message
news:ez**************@TK2MSFTNGP09.phx.gbl...

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

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

--
_____
DC G

[Davide Vernole [MVP]]

DC Gringo <dc******@visiontechnology.net> typed:

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

--
Davide Vernole
MVP ASP/ASP.NET
Microsoft Certified Solution Developer

[Shiva]

Use DataTable.Rows.Count property.

"DC Gringo" <dc******@visiontechnology.net> wrote in message
news:ez**************@TK2MSFTNGP09.phx.gbl...
How can I check for the number of records in a table?

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

--
_____
DC G