Posts by GonKas

Thanks people for your support!

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