Loading

Paging properties for a VB.NET DataGrid

jpknarr

So i can populate the datagrid now and i have the paging properties set at 10 records per page. I am coming across a problem when I use the navigational buttons to "flip" to the next page. The data seems to remain constant. Has anyone had this occur to them, and if so, how do you correct the problem?? Thank you in advance. DJ

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

jayesh192722y ago
Try this might this help ' if SELECT TOP is checked If selectTop Then sql = "SELECT TOP " & pageSize & " CustomerID, CompanyName, " & _ " ContactName FROM Customers " & _ "WHERE CustomerID > '" & lastVisibleCustomer & "' ORDER BY CustomerID" GetTopData(sql, 2) Else ds = GetPagedData(adapter, curIndex, pageSize) curIndex = curIndex + pageSize DataGrid1.DataSource = ds.DefaultViewManager End If Jayesh
+1