代码改变世界

GridView控件+AspNetPager分页

2020-05-29 00:32  idea555  阅读(97)  评论(0)    收藏  举报

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="List1.aspx.cs" Inherits="WebForm.List1" %>
<%@ Register Assembly="AspNetPager" Namespace="Wuqi.Webdiyer" TagPrefix="webdiyer" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
<title></title>
</head>
<body>
<form id="form1" runat="server">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False">
<Columns>

<asp:BoundField DataField="Id" HeaderText="用户ID" ReadOnly="True" />
<asp:BoundField DataField="Name" HeaderText="姓名" ReadOnly="True" />

</Columns>
</asp:GridView>

<webdiyer:AspNetPager ID="AspNetPager1" runat="server" PageSize="3"
onpagechanging="AspNetPager1_PageChanging">
</webdiyer:AspNetPager>


</form>
</body>
</html>


using Common;
using Logic;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Wuqi.Webdiyer;

namespace WebForm
{
public partial class List1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (!IsPostBack)
{
DisplayData(1, AspNetPager1.PageSize);
AspNetPager1.RecordCount = SqlHelper.ExecuteScalar(CommandType.Text, "select count(*) from student") == null ? 0 : Convert.ToInt32(SqlHelper.ExecuteScalar(CommandType.Text, "select count(*) from student"));

}
}
}

private void DisplayData(int pageIndex, int pageSize)
{
string sqlText = "select * from student";
string orderByText = "Order by Id ";

sqlText = PageHelper.GetPageSql(sqlText, orderByText, pageIndex, pageSize);


DataTable dt = SqlHelper.FillDataTable(CommandType.Text, sqlText);

GridView1.DataSource = dt;
GridView1.DataBind();
}


protected void AspNetPager1_PageChanging(object src, PageChangingEventArgs e)
{
DisplayData(e.NewPageIndex, AspNetPager1.PageSize);
}


// public DataTable FenyeSelect(int startIndex, int endIndex)
//{
// string sql = "with template as (select ROW_NUMBER() over(order by ID desc) as rowNumber,*from Student) select * from Student where rowNumber between @startIndex and @endIndex";
// SqlParameter[] sqlParameters = { new SqlParameter("@startIndex", startIndex),
// new SqlParameter("@endIndex",endIndex)};
// DataTable dt = SqlHelper.FillDataTable(CommandType.Text,sql, sqlParameters);
// return dt;
//}
}
}