谁可以给DATALIST分页的所有代码
解决方案 »
- 发布的网站在客户机上出现的问题?在我机器上是没问题的
- 难道是我自己想当然地认为是这样吗?关于Panel动态加载控件!!!
- 有没有简单的方法把xml的数据倒进数据表里?
- 跪求一个简单的正则表达试 up 给分请见贴的朋友给帮帮忙
- 如何用代码给ASP.NET 的TEXTBOX 空间加个 RequireFieldValidator ?
- w3wp.exe占用资源过大的问题(被挂马后)
- inherit question in Asp.net Ajax Framework 3.5
- 对于MyWebService.asmx中大家的用法
- 怎么在客户端的脚本中控制SESSION的值?
- 从EXCEL中读取数据到DataGrid,但无法正常显示?为什么?
- 同时安装.NET2005和.NET2003的Sql Server连接问题
- DropDownList联动的问题……急
create procedure wzl
(@startIndex int,
@pageSize int)
as
set nocount on
declare @MyTable table(id int identity(1,1),nid int);
declare @PageUpperBound int;
set @PageUpperBound=@startIndex+@pagesize-1;
set rowcount @PageUpperBound;
insert into @MyTable(nid) select orderid from orders;
select * from @MyTable as x left outer join orders on orders.orderid = x.id
where x.id between @startIndex and @PageUpperBound
set nocount off
RETURN用哪个AspNetPager页面代码
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Security;
using System.Text.RegularExpressions;
using System.Data.SqlClient;
namespace Test
{ public class WebForm1 : System.Web.UI.Page
{
protected System.Web.UI.WebControls.DataList DataList1;
protected Wuqi.Webdiyer.AspNetPager AspNetPager1;
private void Page_Load(object sender, System.EventArgs e)
{
SqlConnection conn = new SqlConnection("server=.;pwd=sa;uid=sa;database=northwind");
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.CommandText = "select count(orderid) from orders";
conn.Open();
this.AspNetPager1.RecordCount = (int)cmd.ExecuteScalar();
conn.Close();
bindData();
}
void bindData()
{
SqlConnection conn = new SqlConnection("server=.;pwd=sa;uid=sa;database=northwind");
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = conn;
cmd.CommandText = "wzl";
cmd.Parameters.Add("@startIndex",this.AspNetPager1.StartRecordIndex);
cmd.Parameters.Add("@pageSize",this.AspNetPager1.PageSize);
SqlDataAdapter sda = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
sda.Fill(ds);
this.DataList1.DataSource = ds.Tables[0].DefaultView;// DataList1.DataSource = SqlHelper.ExecuteReader(CommandType.StoredProcedure,"P_GetPagedOrders2000",
// new SqlParameter("@startIndex", AspNetPager1.StartRecordIndex),
// new SqlParameter("@pageSize", AspNetPager1.PageSize));
this.DataList1.DataBind();
} #region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.AspNetPager1.PageChanged += new System.EventHandler(this.AspNetPager1_PageChanged);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion private void AspNetPager1_PageChanged(object sender, System.EventArgs e)
{
bindData();
} }
}