DataGrid Paging...Help

Neliel Tu Oderschvank · Apr 28, 2012

I am trying to enable paging on a simple datagrid (see attached) without any luck. Can anyone help. thanks, Dan Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here If Not Page.IsPostBack Then DataGrid1.DataBind() End If End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click OleDbDataAdapter1.SelectCommand.Parameters("weight").Value = http://aspmessageboard.com/archive/index.php/TextBox1.Text OleDbDataAdapter1.Fill(DataSet21) DataGrid1.DataBind() End Sub Sub binddata() OleDbDataAdapter1.SelectCommand.Parameters("weight").Value = TextBox1.Text End Sub End ClassIm just guessing what your problem is here, but... Private Sub DataGrid1_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEvent Args) Handles DataGrid1.PageIndexChanged DataGrid1.CurrentPageIndex = e.NewPageIndex OleDbDataAdapter1.SelectCommand.Parameters("weight").Value = TextBox1.Text OleDbDataAdapter1.Fill(DataSet21) DataGrid1.DataBind() End Sub This assumes that somewhere (probably in your aspx) you turned AllowPaging=true and set PageSize to a number. The problem I ran into was that even though I set those parameters in the aspx, it didn't actually switch pages when I clicked on the page numbers. So what this sub does, is change what page the grid is on, then rebind the grid so the changes take effect.What you described is the exact problem I am having (a page displays, with additional page numbers and when I click one the page stays the same). I verified that AllowPaging="true" and that OnPageIndexChanged points to the right place. Any other suggestions? thanks, DanCan you post your complete code?? It is probably something small that is just eluding you.Here is the VB Code and the HTML DataGrid Code at the bottom. thanks, Dan Public Class WebForm2 Inherits System.Web.UI.Page Protected WithEvents OleDbDataAdapter1 As System.Data.OleDb.OleDbDataAdapter Protected WithEvents OleDbSelectCommand1 As System.Data.OleDb.OleDbCommand Protected WithEvents OleDbConnection1 As System.Data.OleDb.OleDbConnection Protected WithEvents DataSet21 As rn1.DataSet2 Protected WithEvents TextBox1 As System.Web.UI.WebControls.TextBox Protected WithEvents Button1 As System.Web.UI.WebControls.Button Protected WithEvents DataGrid1 As System.Web.UI.WebControls.DataGrid #Region " Web Form Designer Generated Code " 'This call is required by the Web Form Designer. <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() Me.OleDbDataAdapter1 = New System.Data.OleDb.OleDbDataAdapter() Me.OleDbSelectCommand1 = New System.Data.OleDb.OleDbCommand() Me.OleDbConnection1 = New System.Data.OleDb.OleDbConnection() Me.DataSet21 = New rn1.DataSet2() CType(Me.DataSet21, System.ComponentModel.ISupportInitialize).BeginIni t() ' 'OleDbDataAdapter1 ' Me.OleDbDataAdapter1.SelectCommand = Me.OleDbSelectCommand1 Me.OleDbDataAdapter1.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "Physical Features", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("Last Name", "Last Name"), New System.Data.Common.DataColumnMapping("First Name", "First Name"), New System.Data.Common.DataColumnMapping("Middle Name", "Middle Name"), New System.Data.Common.DataColumnMapping("Sex", "Sex"), New System.Data.Common.DataColumnMapping("Weight", "Weight")})}) ' 'OleDbSelectCommand1 ' Me.OleDbSelectCommand1.CommandText = "SELECT [Last Name], [First Name], [Middle Name], Sex, Weight FROM [Physical Featu" & _ "res] WHERE (Weight = ?)" Me.OleDbSelectCommand1.Connection = Me.OleDbConnection1 Me.OleDbSelectCommand1.Parameters.Add(New System.Data.OleDb.OleDbParameter("Weight", System.Data.OleDb.OleDbType.Decimal, 5, System.Data.ParameterDirection.Input, False, CType(3, Byte), CType(0, Byte), "Weight", System.Data.DataRowVersion.Current, Nothing)) ' 'OleDbConnection1 ' Me.OleDbConnection1.ConnectionString = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial " & _ "Catalog=MSSdb;Data Source=speed;Use Procedure for Prepare=1;Auto Translate=True;" & _ "Packet Size=4096;Workstation ID=SPEED;Use Encryption for Data=False;Tag with col" & _ "umn collation when possible=False" ' 'DataSet21 ' Me.DataSet21.DataSetName = "DataSet2" Me.DataSet21.Locale = New System.Globalization.CultureInfo("en-US") Me.DataSet21.Namespace = "http://www.tempuri.org/DataSet2.xsd" CType(Me.DataSet21, System.ComponentModel.ISupportInitialize).EndInit( ) End Sub Private Sub Page_Init(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Init 'CODEGEN: This method call is required by the Web Form Designer 'Do not modify it using the code editor. InitializeComponent() End Sub #End Region Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load 'Put user code to initialize the page here If Not Page.IsPostBack Then BindGrid() End If End Sub Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click OleDbDataAdapter1.SelectCommand.Parameters("weight").Value = TextBox1.Text OleDbDataAdapter1.Fill(DataSet21) BindGrid() End Sub Sub DataGrid_Page(ByVal sender As Object, ByVal e As DataGridPageChangedEventArgs) 'Set CurrentPageIndex to page user clicked. 'DataGrid1.CurrentPageIndex = e.NewPageIndex 'Rebind the data BindGrid() End Sub Sub BindGrid() DataGrid1.DataSource = DataSet21 DataGrid1.DataBind() End Sub End Class ====================================== <%@ Page Language="vb" AutoEventWireup="false" Codebehind="WebForm2.aspx.vb" Inherits="rn1.WebForm2"%> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML> <HEAD> <title>WebForm2</title> <meta name="GENERATOR" content="Microsoft Visual Studio.NET 7.0"> <meta name="CODE_LANGUAGE" content="Visual Basic 7.0"> <meta name="vs_defaultClientScript" content="JavaScript"> <meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5"> </HEAD> <body MS_POSITIONING="GridLayout"> <form id="Form1" method="post" runat="server"> <asp:TextBox id="TextBox1" style="Z-INDEX: 101; LEFT: 119px; POSITION: absolute; TOP: 56px" runat="server"></asp:TextBox> <asp:Button id="Button1" style="Z-INDEX: 102; LEFT: 295px; POSITION: absolute; TOP: 53px" runat="server" Text="Search"></asp:Button> <asp

ataGrid id=DataGrid1 style="Z-INDEX: 103; LEFT: 80px; POSITION: absolute; TOP: 106px" runat="server" DataSource="<%# DataSet21 %>" DataMember="Physical Features" AllowPaging="True" OnPageIndexChanged="DataGrid_Page" PageSize="10"> <PagerStyle Mode="NumericPages"></PagerStyle> </asp

ataGrid> </form> </body> </HTML>

DataGrid Paging...Help

Neliel Tu Oderschvank

New Member