. 在项目中添加AspNetPager.dll引用。
2.***.aspx代码:
AutoGenerateColumns="False">
xml:namespace prefix = webdiyer /><
webdiyer:aspnetpager id="AspNetPager1" runat="server"
ShowCustomInfoSection="Left" UrlPaging="true" ShowBoxThreshold="5" PageSize="25"
pagingbuttontype="Image" width="80%" ImagePath="../../Style/images/pager/"
ButtonImageNameExtension="n" ButtonImageExtension=".gif" AlwaysShow="true"
DisabledButtonImageNameExtension="g" NumericButtonTextFormatString="[{0}]"
CpiButtonImageNameExtension="r" PagingButtonSpacing="10px" ButtonImageAlign="left"
OnPageChanged="AspNetPager1_PageChanged">
3.***.aspx.cs代码:
protected void Page_Load(object sender, EventArgs e)
{
GridViewBind();
}
private void GridViewBind()
{
SqlConnection con = new SqlConnection("server=128.1.3.68;database=XYGL;uid=hatest;pwd=hatest");
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "P_newpager";
int pageindex = 0;
string strWhere = "";
if (AspNetPager1.CurrentPageIndex < 1)
{
pageindex = 1;
}
else
{
pageindex = AspNetPager1.CurrentPageIndex;
}
SqlParameter[] parameters ={
new SqlParameter("@tblname",SqlDbType.VarChar,255),
new SqlParameter("@strGetFields",SqlDbType.VarChar,1000),
new SqlParameter("@fldName",SqlDbType.VarChar,255),
new SqlParameter("@PageSize",SqlDbType.Int,4),
new SqlParameter("@PageIndex",SqlDbType.Int,4),
new SqlParameter("@doCount",SqlDbType.Bit),
new SqlParameter("@OrderType",SqlDbType.Bit),
new SqlParameter("@strWhere",SqlDbType.VarChar,2000) };
parameters[0].Value = "usiKHKHDJ";//表或视图名
parameters[1].Value = "ID,JSID,KHID,KHDM,MC,DLRQ";//显示字段
parameters[2].Value = "ID";//以某字段排序
parameters[3].Value = AspNetPager1.PageSize;//多少条为一页
parameters[4].Value = pageindex;//索引页
parameters[5].Value = 0;//默认0就行了
parameters[6].Value = 1;//这里
的1是降序,0为升序
parameters[7].Value = strWhere;//查询条件组合
foreach (SqlParameter p in parameters)
{
cmd.Parameters.Add(p);
}
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
//动态设置用户自定义文本内容
AspNetPager1.RecordCount = int.Parse(ds.Tables[1].Rows[0][0].ToString());
AspNetPager1.CustomInfoHTML = "共" + AspNetPager1.RecordCount.ToString() + "条,";
AspNetPager1.CustomInfo
HTML += "" + AspNetPager1.PageCount.ToString() + "页,";
AspNetPager1.CustomInfoHTML += "第" + AspNetPager1.CurrentPageIndex.ToString() + "页";
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();
}
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
GridViewBind();
}
4.存储过程:
CREATE PROCEDURE [dbo].[P_ne