SQlserver的分页，以及连接vs的Ajax无刷新分页

最新推荐文章于 2024-05-24 11:13:20 发布

shuo785869451

最新推荐文章于 2024-05-24 11:13:20 发布

阅读量526

点赞数

分类专栏：分页文章标签： SQL Server Visual Studio 分页三层架构

本文链接：https://blog.csdn.net/shuo785869451/article/details/8955211

版权

分页专栏收录该内容

1 篇文章 0 订阅

订阅专栏

一

1.sql简单分页

//以id为标准，从5到10的数据。

select * from(select row_number() over(order by Id)as rownumber,*from T_News1)T
where rownumber>=5 and rownumber<=10

2.sql分页

//定义两个变量于存储过程中，每页5条数据，第二页

GO
create proc pro_fenye
@pagesize int,
@pageindex int
as
select * from(select ROW_NUMBER() over(order by Id) as rownumber,* from T_News1)T
WHERE rownumber>(@pageindex-1)*@pagesize AND rownumber<=@pageindex*@pagesize
GO
EXEC pro_fenye 5,2

二

三层架构构建分页

1.用动软生成三层并改写其中无用内容

2.前台：

后台：

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 _5_21分页
{
public partial class WebForm1 : System.Web.UI.Page
{
int pagesize = 10;
int pageindex = 1;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
ViewState["pageindex"] = 1;
GetLastPageindex();
LoadData();
}
}
private void GetLastPageindex()
{
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 LoadData()
{
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;
LoadData();
}

protected void btnPre_Click(object sender, EventArgs e)
{
int pageindex = Convert.ToInt32(ViewState["pageindex"]);
if (pageindex>1)
{
pageindex--;
ViewState["pageindex"] = pageindex;
LoadData();
}
}

protected void btnNext_Click(object sender, EventArgs e)
{
int pageindex = Convert.ToInt32(ViewState["pageindex"]);
if (pageindex<Convert.ToInt32(ViewState["lastpageindex"]))
{
pageindex++;
ViewState["pageindex"] = pageindex;
LoadData();
}
}

protected void btnLast_Click(object sender, EventArgs e)
{
ViewState["pageindex"] = ViewState["lastpageindex"];
LoadData();
}

protected void LinkButton5_Click(object sender, EventArgs e)
{
int result;
if (int.TryParse(txtPageindex.Text, out result) == true)
{
ViewState["pageindex"] = txtPageindex.Text.Trim();
LoadData();
}
else
{
txtPageindex.Text = "请输入合法的数字";
}

}
}
}

Web.config：//连接数据库

<?xml version="1.0" encoding="utf-8"?>



<configuration>
<system.web>
<compilation debug="true" targetFramework="4.0" />
</system.web>
<connectionStrings>
<add name="sqlservercon" connectionString="Data Source=PC-201303062250;Initial Catalog=News;Persist Security Info=True;User ID=sa;Password=ls785869"/>
</connectionStrings>
</configuration>

shuo785869451

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
SQlserver的分页，以及连接vs的Ajax无刷新分页

一1.sql简单分页//以id为标准，从5到10的数据。select * from(select row_number() over(order by Id)as rownumber,*from T_News1)Twhere rownumber>=5 and rownumber2.sql分页//定义两个变量于存储过程中，每页5条数据，第二页GOcreate pr
复制链接

扫一扫