【存储过程】三层+存储过程实现分页示例代码-分页

欢迎您访问我爱IT技术网，今天小编为你分享的编程技术是：【三层+存储过程实现分页示例代码】，下面是详细的讲解！

三层+存储过程实现分页示例代码

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
namespace 练习
{
public partial class paging : System.Web.UI.Page
{
int pagesize=10;
int pageindex=1;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["pageindex"]=1;
LadaData();
GetListPageindex();
}
}
private void GetListPageindex()
{
BLL.T_News1 bnews=new BLL.T_News1();
int totalcount=bnews.GetRecordCount("");
if (totalcount % pagesize==0)
{
ViewState["lastpageindex"]=totalcount / pagesize;
}
else
{
ViewState["lastpageindex"]=totalcount / pagesize + 1;
}
}
private void LadaData()
{
BLL.T_News1 bnews=new BLL.T_News1();
DataTable dt=bnews.GetListDataTable(pagesize, Convert.ToInt32(ViewState["pageindex"]));
this.GridView1.DataSource=dt;
this.GridView1.DataBind();
}
//第一页
protected void btnFirst_Click(object sender, EventArgs e)
{
ViewState["pageindex"]=1;
LadaData();
}
//上一页
protected void btnPre_Click(object sender, EventArgs e)
{
int pageindex=Convert.ToInt32(ViewState["pageindex"]);
if (pagesize>1)
{
pageindex--;
ViewState["pageindex"]=pageindex;
LadaData();
}
}
//下一页
protected void btnNext_Click(object sender, EventArgs e)
{
int pageindex=Convert.ToInt32(ViewState["pageindex"]);
if (pageindex<Convert.ToInt32(ViewState["lastpageindex"]))
{
pageindex++;
ViewState["pageindex"]=pageindex;
LadaData();
}
}
//最后一页
protected void btnLast_Click(object sender, EventArgs e)
{
ViewState["pageindex"]=ViewState["lastpageindex"];
LadaData();
}
//跳转页面
protected void btnSkip_Click(object sender, EventArgs e)
{
int result;
if (int.TryParse(txtPagination.Text, out result)==true)
{
ViewState["pageindex"]=txtPagination.Text.Trim();
LadaData();
}
else
{
txtPagination.Text="请输入合法的数字";
}
}
}
}

关于三层+存储过程实现分页示例代码的用户互动如下：

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细

　　相关问题：

　　答： >>详细