Paging through a portion of a table in a DataGrid

[glenn]

Hi folks,

I am trying to page through a portion of the data in a table and therefore I
think I need to use Custom Paging.

.... but, I am wondering if I can pass a dataset that was obtained through a
function that returns a dataset that is a portion of a table. Apparently I
cannot do this as I keep getting the CurrentPageInde x must be or = 0 and <
PageCount error.

I guess I do not fully understand Custom Paging yet, so I will do some
reading on it but it seems that my method should work. My only thought is
that the PageCount is based on ALL of the records in a table and not just the
subset of records returned from my function. Also, I have found that
PageCount is readonly.

Here is the code I am using:

Function GetRecords(ByVa l record As Integer) As System.Data.Dat aSet

Dim connectionStrin g As String = "Provider=Micro soft.Jet.OLEDB. 4.0; Ole
DB Services=-4; Data Source=C:\path\ accessfile.mdb"
Dim dbConnection As System.Data.IDb Connection = New
System.Data.Ole Db.OleDbConnect ion(connectionS tring)

Dim queryString As String = "SELECT [tablename].* FROM [tablename] WHERE
([discussion].[record] = @anotherrecord) "
Dim dbCommand As System.Data.IDb Command = New Data.OleDb.OleD bCommand
dbCommand.Comma ndText = queryString
dbCommand.Conne ction = dbConnection

Dim dbParam_record As System.Data.IDa taParameter = New
System.Data.Ole Db.OleDbParamet er
dbParam_record. ParameterName = "@record"
dbParam_record. Value = record
dbParam_record. DbType = System.Data.DbT ype.Int32
dbCommand.Param eters.Add(dbPar am_record)

Dim dataAdapter As System.Data.IDb DataAdapter = New
System.Data.Ole Db.OleDbDataAda pter
dataAdapter.Sel ectCommand = dbCommand
Dim dataSet As System.Data.Dat aSet = New
System.Data.Dat aSet
dataAdapter.Fil l(dataSet)

Return dataSet
End Function
Sub BindData(sortEx pr as String)

Dim dataSet As DataSet = New DataSet()

dataSet = GetRecord(recor dID)

'Finally, specify the DataSource and call DataBind()
DataGrid1.DataS ource = dataset
DataGrid1.DataB ind()

End Sub

Any feedback is appreciated.
- Glenn

[Augustin Prasanna]

Paging in Dataset assumes that the dataset contains complete set of data.

-Augustin

"glenn" wrote:

Hi folks,

I am trying to page through a portion of the data in a table and therefore I
think I need to use Custom Paging.

... but, I am wondering if I can pass a dataset that was obtained through a
function that returns a dataset that is a portion of a table. Apparently I
cannot do this as I keep getting the CurrentPageInde x must be or = 0 and <
PageCount error.

I guess I do not fully understand Custom Paging yet, so I will do some
reading on it but it seems that my method should work. My only thought is
that the PageCount is based on ALL of the records in a table and not just the
subset of records returned from my function. Also, I have found that
PageCount is readonly.

Here is the code I am using:

Function GetRecords(ByVa l record As Integer) As System.Data.Dat aSet

Dim connectionStrin g As String = "Provider=Micro soft.Jet.OLEDB. 4.0; Ole
DB Services=-4; Data Source=C:\path\ accessfile.mdb"
Dim dbConnection As System.Data.IDb Connection = New
System.Data.Ole Db.OleDbConnect ion(connectionS tring)

Dim queryString As String = "SELECT [tablename].* FROM [tablename] WHERE
([discussion].[record] = @anotherrecord) "
Dim dbCommand As System.Data.IDb Command = New Data.OleDb.OleD bCommand
dbCommand.Comma ndText = queryString
dbCommand.Conne ction = dbConnection

Dim dbParam_record As System.Data.IDa taParameter = New
System.Data.Ole Db.OleDbParamet er
dbParam_record. ParameterName = "@record"
dbParam_record. Value = record
dbParam_record. DbType = System.Data.DbT ype.Int32
dbCommand.Param eters.Add(dbPar am_record)

Dim dataAdapter As System.Data.IDb DataAdapter = New
System.Data.Ole Db.OleDbDataAda pter
dataAdapter.Sel ectCommand = dbCommand
Dim dataSet As System.Data.Dat aSet = New
System.Data.Dat aSet
dataAdapter.Fil l(dataSet)

Return dataSet
End Function
Sub BindData(sortEx pr as String)

Dim dataSet As DataSet = New DataSet()

dataSet = GetRecord(recor dID)

'Finally, specify the DataSource and call DataBind()
DataGrid1.DataS ource = dataset
DataGrid1.DataB ind()

End Sub

Any feedback is appreciated.
- Glenn