Data Adapter ...

Data Adapter's fill method does allow us to do paging where we can specify the number of records to fetch and stuff. However, it doesn't tell us how many records in total were affected by the Select Query ??? If we do not know total number of records we cannot get the PageCount/RecordCount .. any ideas ?

seems that we all use the same type of programs
here is the code for displaying number of record and position

VB Code:

Private Sub displayrecordposition()
        'display record position and number of records
        Dim intRecordCount As Integer
        Dim intRecordPosition As Integer
 
        intRecordCount = DsSQL1.Tables("dem").Rows.Count
        If intRecordCount = 0 Then
            lblRecordNumber.Text = "(No Records)"
        Else
            intRecordPosition = Me.BindingContext(DsSQL1, "dem").Position + 1
            lblRecordNumber.Text = "Record " & intRecordPosition.ToString _
            & " of " & intRecordCount.ToString
        End If
    End Sub

dssql is my data set and dem is my table name