Custom Paging From ADO dataset

Rabbitdildosr · Apr 28, 2012

I found this article in the msdn: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemwebuiwebcontrolsdatagridclassallowcusto mpagingtopic.asp It works great. I tried modifying it to pull a dataset intead of the collection object. The results show up fine. You can click the page buttons and they move position, but i cannot get the display to change in sync with the page buttons. In otherwords, the datagrid always shows the first set of results no matter what i click on. Does anyone know how to do custom paging from a data set out of an Access database??? Any help would be appricated!!!!!! Below is the code that i modifed: <%@ Page SmartNavigation="true" %>  <% @Import Namespace="System.Data" %> <% @Import Namespace="System.Data.OleDb" %> <html> <script language="VB" runat="server"> Dim start_index As Integer Function CreateDataSource() As ICollection Dim DS As DataSet Dim MyCommand As OleDbDataAdapter MyCommand = New OleDbDataAdapter("SELECT * FROM tblOrdersProcessed " , MyConnection) DS = new DataSet() MyCommand.Fill(DS, "tblOrdersProcessed") Dim Source As DataView = DS.Tables("tblOrdersProcessed").DefaultView Return Source End Function 'CreateDataSource Sub Page_Load(sender As Object, e As EventArgs) If CheckBox1.Checked Then ItemsGrid.PagerStyle.Mode = PagerMode.NumericPages Else ItemsGrid.PagerStyle.Mode = PagerMode.NextPrev End If If Not IsPostBack Then start_index = 0 ItemsGrid.VirtualItemCount = 80 End If BindGrid() End Sub 'Page_Load Sub Grid_Change(sender As Object, e As DataGridPageChangedEventArgs) ItemsGrid.CurrentPageIndex = e.NewPageIndex start_index = ItemsGrid.CurrentPageIndex * ItemsGrid.PageSize BindGrid() End Sub 'Grid_Change Sub BindGrid() ItemsGrid.DataSource = CreateDataSource() ItemsGrid.DataBind() End Sub 'BindGrid </script> <body> <form runat=server> <h3>DataGrid Custom Paging Example</h3> <asp

ataGrid id="ItemsGrid" runat="server" BorderColor="black" BorderWidth="1" CellPadding="3" AllowPaging="true" AllowCustomPaging="true" PageSize="5" AutoGenerateColumns="false" OnPageIndexChanged="Grid_Change"> <PagerStyle NextPageText="Forward" PrevPageText="Back" Position="Bottom" PageButtonCount="5" BackColor="#00aaaa"> </PagerStyle> <AlternatingItemStyle BackColor="yellow"> </AlternatingItemStyle> <HeaderStyle BackColor="#00aaaa"> </HeaderStyle> <Columns> <asp:BoundColumn HeaderText="Number" DataField="ID"/> <asp:BoundColumn HeaderText="Number" DataField="OrderID"/> <asp:BoundColumn HeaderText="Item" DataField="VendorID"/> <asp:BoundColumn HeaderText="Price" DataField="VendorCost" DataFormatString="{0:c}"> <ItemStyle HorizontalAlign="right"> </ItemStyle> </asp:BoundColumn> </Columns> </asp

ataGrid> <asp:CheckBox id="CheckBox1" Text = "Show page navigation" AutoPostBack="true" runat="server"/> </form> </body> </html>

Custom Paging From ADO dataset

Rabbitdildosr

New Member