发信人: Nineteen (－_－#!), 信区: DotNET
标  题: [合集] datagrid翻页问题
发信站: BBS 水木清华站 (Tue Dec  9 20:09:42 2003), 站内

☆─────────────────────────────────────☆
   Banfeeling (Boy To Man) 于  (Tue Dec  9 10:46:03 2003)  提到:

<asp:datagrid id="DataGrid1" runat="server" AllowPaging="True" AllowCustomPaging="True" AutoGenerateColumns="False" OnPageIndexChanged="MyDataGrid_Page">

    Public Sub MyDataGrid_Page(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs)
        DataGrid1.CurrentPageIndex = e.NewPageIndex
        OleDbCommand1.CommandText = "select * from 表名 where lstate=103"
        Dim ds As DataSet = New DataSet()
        Dim MyAdapter As OleDbDataAdapter = New OleDbDataAdapter(OleDbCommand1.CommandText, OleDbConnection1)
        MyAdapter.Fill(ds, "表名")
        Response.Write("index值是" + DataGrid1.CurrentPageIndex.ToString)
        Dim dv As DataView = New DataView(ds.Tables("tletter_each"))
        DataGrid1.DataSource = dv
        DataGrid1.DataBind()
        OleDbConnection1.Close()
    End Sub

点了代表不同页面的数字，response出来的index倒是变了，但是datagrid内容却没有变

thx in advance


※ 来源:·BBS 水木清华站 smth.org·[FROM: 162.105.39.19]


☆─────────────────────────────────────☆
   heweiqi (Ricky) 于  (Tue Dec  9 12:29:11 2003)  提到:

看着挺好的啊

【 在 Banfeeling (Boy To Man) 的大作中提到: 】
∶<asp:datagrid id="DataGrid1" runat="server" AllowPaging="True" AllowCustomPaging="True" AutoGenerateColumns="False" OnPageIndexChanged="MyDataGrid_Page">
∶Public Sub MyDataGrid_Page(ByVal source As Object, ByVal e As System.Web.UI.WebControls.DataGridPageChangedEventArgs)
∶DataGrid1.CurrentPageIndex = e.NewPageIndex
∶OleDbCommand1.CommandText = "select * from 表名 where lstate=103"
∶Dim ds As DataSet = New DataSet()
∶Dim MyAdapter As OleDbDataAdapter = New OleDbDataAdapter(OleDbCommand1.CommandText, OleDbConnection1)
∶MyAdapter.Fill(ds, "表名")
∶Response.Write("index值是" + DataGrid1.CurrentPageIndex.ToString)
∶Dim dv As DataView = New DataView(ds.Tables("tletter_each"))
∶DataGrid1.DataSource = dv
∶DataGrid1.DataBind()
∶...................



☆─────────────────────────────────────☆
   Banfeeling (Boy To Man) 于  (Tue Dec  9 14:36:57 2003)  提到:

是啊，我也觉得奇怪，CurrentPageIndex已经变了，但是内容还是表里面第一页的内容
会不会是sqlserver的问题呢？那个表主键，索引什么的都没有设置

【 在 heweiqi (Ricky) 的大作中提到: 】
∶看着挺好的啊



※ 来源:·BBS 水木清华站 smth.org·[FROM: 162.105.39.19]


☆─────────────────────────────────────☆
   cartridge (态度决定一切) 于  (Tue Dec  9 15:56:13 2003)  提到:

把AllowCustomPaging去掉，使用自动翻页功能就可以解决
【 在 Banfeeling (Boy To Man) 的大作中提到: 】
∶<asp:datagrid id="DataGrid1" runat="server" AllowPaging="True" AllowCustom..
∶
∶Public Sub MyDataGrid_Page(ByVal source As Object, ByVal e As System.W..
∶DataGrid1.CurrentPageIndex = e.NewPageIndex
∶OleDbCommand1.CommandText = "select * from 表名 where lstate=103"
∶Dim ds As DataSet = New DataSet()
∶Dim MyAdapter As OleDbDataAdapter = New OleDbDataAdapter(OleDbComm..
∶MyAdapter.Fill(ds, "表名")
∶Response.Write("index值是" + DataGrid1.CurrentPageIndex.ToString)
∶Dim dv As DataView = New DataView(ds.Tables("tletter_each"))
∶...................



☆─────────────────────────────────────☆
   heweiqi (Ricky) 于  (Tue Dec  9 17:46:59 2003)  提到:

呵呵，看漏了

【 在 cartridge (态度决定一切) 的大作中提到: 】
∶把AllowCustomPaging去掉，使用自动翻页功能就可以解决




☆─────────────────────────────────────☆
   wmjordan (琴韵深深——光子时代) 于  (Tue Dec  9 18:01:28 2003)  提到:

Though auto paging is handy.

It can lead to a potential that the web page your applications  
generate to be horribly tremendous, if there are lots of data
in your grid.

You must set ViewState to true when using auto paging.

【 在 heweiqi (Ricky) 的大作中提到: 】
∶呵呵，看漏了
∶
∶【 在 cartridge (态度决定一切) 的大作中提到: 】
∶: 把AllowCustomPaging去掉，使用自动翻页功能就可以解决
∶
∶



☆─────────────────────────────────────☆
   Banfeeling (Boy To Man) 于  (Tue Dec  9 19:48:24 2003)  提到:

谢谢，搞定了 ：） 一bow，二bow，三bow
本来也没用那个allowcustompaging的，但datasourse用msdn上的OleDbDataReader
每次就出错，说selected datasource does not implement ICollection
现在换成dataset.table("表").defaultview了


【 在 cartridge (态度决定一切) 的大作中提到: 】
∶把AllowCustomPaging去掉，使用自动翻页功能就可以解决



※ 来源:·BBS 水木清华站 smth.org·[FROM: 162.105.39.19]


上一篇
返回上一页
回到目录
回到页首
下一篇