页面代码如下:
代码如下 | 复制代码 |
<asp:ListView runat="server" ID="_simpleTableListView"> <LayoutTemplate> <table> <thead> <tr> <th id="Th1" runat="server"> ID</th> <th id="Th2" runat="server"> StudentID</th> <th id="Th3" runat="server"> Name</th> <th id="Th4" runat="server"> Math</th> <th id="Th5" runat="server"> English</th> <th id="Th6" runat="server"> Chinese</th> </tr> </thead> <tbody> <asp:PlaceHolder runat="server" ID="itemPlaceholder" /> </tbody> </table> </LayoutTemplate> <ItemTemplate> <tr> <td> <asp:Label ID="IDLabel" runat="server" Text='<%# Eval("ID") %>' /> </td> <td> <asp:Label ID="StudentIDLabel" runat="server" Text='<%# Eval("StudentID") %>' /> </td> <td> <asp:Label ID="NameLabel" runat="server" Text='<%# Eval("Name") %>' /> </td> <td> <asp:Label ID="MathLabel" runat="server" Text='<%# Eval("Math") %>' /> </td> <td> <asp:Label ID="EnglishLabel" runat="server" Text='<%# Eval("English") %>' /> </td> <td> <asp:Label ID="ChineseLabel" runat="server" Text='<%# Eval("Chinese") %>' /> </td> </tr> </ItemTemplate> </asp:ListView> <asp:DataPager ID="DataPager2" runat="server" PagedControlID="_simpleTableListView" PageSize="2" onprerender="DataPager2_PreRender"> <Fields> <asp:NextPreviousPagerField ButtonType="Button" ShowFirstPageButton="True" ShowLastPageButton="True" /> </Fields> </asp:DataPager> |
后台代码:
代码如下 | 复制代码 |
protected void DataPager2_PreRender(object sender, EventArgs e) { BindData(); } private void BindData() { using (OleDbConnection conn = new OleDbConnection(OleDbHelper.ConnectionString)) { string sql = "select * from studentscore"; OleDbDataAdapter dp=new OleDbDataAdapter(sql,conn); DataTable dt = new DataTable(); dp.Fill(dt); _simpleTableListView.DataSource = dt; _simpleTableListView.DataBind(); } } |
注意:使用本方法,不需要在页面的Page_Load事件中绑定数据到ListView控件,
否则分页会有问题。
第2种方法:
代码如下 | 复制代码 |
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { BindData(); } } protected void _simpleTableListView_PagePropertiesChanging(object sender, PagePropertiesChangingEventArgs e) { DataPager2.SetPageProperties(e.StartRowIndex, e.MaximumRows, false); BindData(); } |
时间: 2024-10-31 19:41:58