我是webform ,使用的是 Datagrid 属性生成器里面设置的 翻页功能可是每次翻页都要在 PageIndexChanged 事件里面再一次 初始化我的datagrid一次链接数据库
导入数据集
捆绑datagrid属性然后再 DataGrid1.CurrentPageIndex = e.NewPageIndex
DataGrid1.DataBind()
才能实现为什么每次都要再访问一次数据库,请问可以省去哪些步骤啊??为什么我调不出来!完整代码如下Private Sub DataGrid1_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles DataGrid1.PageIndexChanged
mycommand.CommandText = "Select w , ww from w where cid = " & Session("mycid") mydataadapter.SelectCommand = mycommand myconn.Open() mydataadapter.Fill(DataSet1) DataGrid1.Visible = True myconn.Close() DataGrid1.CurrentPageIndex = e.NewPageIndex
DataGrid1.DataBind() End Sub
导入数据集
捆绑datagrid属性然后再 DataGrid1.CurrentPageIndex = e.NewPageIndex
DataGrid1.DataBind()
才能实现为什么每次都要再访问一次数据库,请问可以省去哪些步骤啊??为什么我调不出来!完整代码如下Private Sub DataGrid1_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles DataGrid1.PageIndexChanged
mycommand.CommandText = "Select w , ww from w where cid = " & Session("mycid") mydataadapter.SelectCommand = mycommand myconn.Open() mydataadapter.Fill(DataSet1) DataGrid1.Visible = True myconn.Close() DataGrid1.CurrentPageIndex = e.NewPageIndex
DataGrid1.DataBind() End Sub
导入数据集
捆绑datagrid属性这些过程写成一个方法,然后在调用就是了。使用DataGrid的过程中,以上步骤会频繁使用到。
mycommand.CommandText = "Select w , ww from w where cid = " & Session("mycid") mydataadapter.SelectCommand = mycommand myconn.Open() mydataadapter.Fill(DataSet1) DataGrid1.Visible = True myconn.Close()
DataGrid1.DataBind()End SubPrivate Sub DataGrid1_PageIndexChanged(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs) Handles DataGrid1.PageIndexChanged
DataGrid1.CurrentPageIndex = e.NewPageIndex
BindGrid()
End Sub