62,244
社区成员




ALTER PROCEDURE [dbo].[Paging]
@PageIndex INT,/*@PageIndex从计数,0为第一页*/
@PageSize INT,/*一个页面有几条记录数*/
@RecordCount INT OUT,/*总记录数*/
@PageCount INT OUT/*页数*/
AS
/*获取记录数*/
SELECT @RecordCount = COUNT(*) FROM T_Page
/*计算页面数据*/
SET @PageCount = CEILING(@RecordCount * 1.0 / @PageSize)
/* 基于SQL SERVER 2005 */
SELECT SerialNumber,ProductNumber,StandardCost,ProductID,[Name] FROM
(SELECT ROW_NUMBER() OVER (ORDER BY ProductID DESC) AS SerialNumber,ProductID,ProductNumber,StandardCost,[Name] FROM T_Page ) AS T
WHERE T.SerialNumber > (@PageIndex * @PageSize) and T.SerialNumber <= ((@PageIndex+1) * @PageSize)
ALTER PROCEDURE [dbo].[Paging]
@PageIndex INT,/*@PageIndex从计数,0为第一页*/
@PageSize INT,/*一个页面有几条记录数*/
AS
/* 基于SQL SERVER 2005 */
SELECT SerialNumber,ProductNumber,StandardCost,ProductID,[Name] FROM
(SELECT ROW_NUMBER() OVER (ORDER BY ProductID DESC) AS SerialNumber,ProductID,ProductNumber,StandardCost,[Name] FROM T_Page ) AS T
WHERE T.SerialNumber > (@PageIndex * @PageSize) and T.SerialNumber <= ((@PageIndex+1) * @PageSize)
public void connection(SqlDataSource SqlDataSource1)
{
// 数据库连接字符串!并连接数据库
SqlDataSource1.ConnectionString = ConfigurationManager.ConnectionStrings["sql"].ConnectionString;
}
public DataTable SelectDataTableSP(SqlDataSource SqlDataSource1, string str)
{
connection(SqlDataSource1);
SqlDataSource1.SelectCommand = str;
SqlDataSource1.SelectCommandType = SqlDataSourceCommandType.StoredProcedure;
return ((DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty)).Table;
}
//首页
public void 首页()
{
SqlDataSource d = new SqlDataSource();
d.SelectParameters.Add("PageIndex", "0");//自己判断吧
d.SelectParameters.Add("PageSize", "10");
Repeater1.DataSource= SelectDataTableSP(d, "Paging");
Repeater1.DataBind();
}
public void 上一页()
{
SqlDataSource d = new SqlDataSource();
d.SelectParameters.Add("PageIndex", "0");//页数自己判断吧
d.SelectParameters.Add("PageSize", "10");
Repeater1.DataSource= SelectDataTableSP(d, "Paging");
Repeater1.DataBind();
}
public void 下一页()
{
SqlDataSource d = new SqlDataSource();
d.SelectParameters.Add("PageIndex", "0");//页数自己判断吧
d.SelectParameters.Add("PageSize", "10");
Repeater1.DataSource= SelectDataTableSP(d, "Paging");
Repeater1.DataBind();
}
public void 最后一页()
{
SqlDataSource d = new SqlDataSource();
d.SelectParameters.Add("PageIndex", "0");//页数自己判断吧
d.SelectParameters.Add("PageSize", "10");
Repeater1.DataSource= SelectDataTableSP(d, "Paging");
Repeater1.DataBind();
}