Counting the number records in a database

There are different methods you can use depending on which tool is polling the data...
(i.e. List or grid)
Howeveran easy way is to use SQL to get the information for you:
http://www.4guysfromrolla.com/webtech/sqlguru/q020100-1.shtml

 

Hi there!

I've a problem...want to return the total number of rows affected by the statement "SELECT * FROM Producao WHERE ProdUserID=UtilizadorID" can anybody give a look to the code below?

Dim ProdUserID As String = "samurai"
Dim ProducaoSource As New SqlDataSource()
ProducaoSource.ConnectionString = ConfigurationManager.ConnectionStrings("seaempiresdbConnectionString1").ToString()
ProducaoSource.SelectCommandType = SqlDataSourceCommandType.Text
ProducaoSource.SelectCommand = "SELECT * FROM Producao WHERE ProdUserID=UtilizadorID"
Dim TotalLinhas As Integer = 0
Try
TotalLinhas = ProducaoSource.Select()
Finally
End Try

The only thing I want is that the var TotalLinhas remains with the number of records...in this case 7 (seven).

Thanks