Problems with query pagination in asp.net

[haggenx]

Hi! I have a problem, i am programming a datagrid in asp.net under webmatrix, only is a connection to access database and show this query in a datagrid, every very good exception for the query pagination. How i can allow what, if the user press a number of page from query, then the asp change the query result to the number page?, attach the code because not work this section, thanks very mucho for you help. --------------------------------------------------------------------------------------------------------- Private connectionString As String = "Provider=Microsoft.Jet.OLEDB.4.0; Ole DB Services=-4; Data Source=C:\lo que se va a estar respaldando\mio\my_access_db.mdb" Private dbConnection As System.Data.IDbConnection = New System.Data.OleDb.OleDbConnection(connectionString) Private dbCommand As System.Data.IDbCommand = New System.Data.OleDb.OleDbCommand private dataAdapter As System.Data.IDbDataAdapter = New System.Data.OleDb.OleDbDataAdapter private dataSet As System.Data.DataSet = New System.Data.DataSet '///////////////////////////////////////// Sub cmdQuery_Click(sender As Object, e As EventArgs) If Len(Trim(txtSQLQUery.Text)) > 0 Then SQLProcesss(Trim(txtSQLQUery.Text)) Else MsgBox("No SQL Query string ingresed!", vbCritical, "Error") End If End Sub '///////////////////////////////////////// Sub SQLProcesss(SQLCommand) dbCommand.CommandText = SQLCommand dbCommand.Connection = dbConnection dataAdapter.SelectCommand = dbCommand dataAdapter.Fill(dataSet) dgData.DataSource = dataSet.Tables(0) dgData.DataBind() MsgBox(Str(dataSet.Tables(0).Rows.Count) + " rows found!", vbInformation, "Query") End Sub '///////////////////////////////////////// Sub cmdClear_Click(sender As Object, e As EventArgs) txtSQLQuery.Text = "" End Sub Sub dgData_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) 'This section not change the query results to the number page dgData.PageIndexChanged = new DataGridPageChangedEventHandler(this.dgrdDepartments_PageIndexChanged) End Sub

Cuando salga el sol, no estare aqui...

[Vasudevan Deepak Kumar]

Check for IsPostBack before databinding again.

Vasudevan Deepak Kumar Personal Homepage Tech Gossips