Recordcount DataSet???

[Joe Keller]

Im new to trying to use ADO.NET but have had alot of previous experience with standard ADO.

How do you get a recordcount for a dataset?

This is what i am doing now.. but I know there has to be a better way.

Private Function MaxRecords() As Integer
   Dim sqlSelect As String
   sqlSelect = "Select [Question] From [tblQuestions]"
   Dim con As New OleDbConnection(ConnectionString)
   Dim cmd As New OleDbCommand(sqlSelect, con)
   Dim reader As OleDbDataReader
   Try
      con.Open()
      reader = cmd.ExecuteReader()
      MaxRecords = 0
      Do While reader.Read()	
         MaxRecords = MaxRecords + 1
      Loop
      reader.Close()
   Catch err As Exception
      lblQuestion.Text = "Error reading survey data. "
      lblQuestion.Text &= err.Message & " "
   Finally
      If (Not con Is Nothing) Then
         con.Close()
      End If
   End Try
End Function

[mhuguet]

Your not using a DataSet in this example. You cannot get a RecordCount from a DataReader. The DataReader is a connected Forward Only object. You can iterate through all of the records and have a counter variable to maintain the count.

You can get the count from a table in a DataSet. Remember a DataSet is a container of Tables which are containers of Rows.

MyRecCount = MyDataSet.Tables(0).Rows.Count