Cant paging
-
Protected Sub btnReport_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnReport.Click Dim dtbTable As DataTable = New DataTable Dim strSQL As String Dim adtSelect As SqlDataAdapter Dim srt1`As String srt1`= TextBox1.Text strSQL = "select * from table1" adtSelect = New SqlDataAdapter(strSQL, conDB) adtSelect.Fill(dtbTable) gridview.DataSource = dtbTable gridview.DataBind() Catch ex As Exception Response.Write(ex.Message.ToString) Finally conDB.Close() End Try End Sub Protected Sub gridview_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles gridview_PageIndexChanging gridview.PageIndex = e.NewPageIndex gridview.DataBind() End Sub
-
Protected Sub btnReport_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnReport.Click Dim dtbTable As DataTable = New DataTable Dim strSQL As String Dim adtSelect As SqlDataAdapter Dim srt1`As String srt1`= TextBox1.Text strSQL = "select * from table1" adtSelect = New SqlDataAdapter(strSQL, conDB) adtSelect.Fill(dtbTable) gridview.DataSource = dtbTable gridview.DataBind() Catch ex As Exception Response.Write(ex.Message.ToString) Finally conDB.Close() End Try End Sub Protected Sub gridview_PageIndexChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewPageEventArgs) Handles gridview_PageIndexChanging gridview.PageIndex = e.NewPageIndex gridview.DataBind() End Sub
Please refer to this http://www.codeproject.com/Messages/1278601/How-to-get-an-answer-to-your-question.aspx[^] for tips on how to ask a question. This is just an unformatted code dump that everyone will just ignore.
Why is common sense not common? Never argue with an idiot. They will drag you down to their level where they are an expert. Sometimes it takes a lot of work to be lazy Please stand in front of my pistol, smile and wait for the flash - JSOP 2012