audibeoxide
New Member
I am searching for a way to display a count of how many rows were returned. for instance:<BR><BR>myConnection = New SqlConnection(connStr)<BR>myCommand = New SqlDataAdapter("select * from Customers", AN_Connection)<BR><BR>lblNowShowing.Text = "Now Showing 1 - 10 of " & COUNT & " Records"<BR><BR><BR>what do i replace COUNT with to make this work?I dont know if you can run this on a command but you can run it on a dataset and I assume your putting your stuff in a dataset to display so this should work:<BR><BR>objDS.Tables("myDSTable").Rows.Count