PagedDataSource 分页类如何实现带 查询呢?? PagedDataSource 分页类如何实现带 查询呢?? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 已实现,完成后台代码: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;namespace Top3Club.hotel{ /// <summary> /// RoomPriceQuery 的摘要说明。 /// </summary> public class RoomPriceQuery: System.Web.UI.Page { protected System.Web.UI.WebControls.Repeater Repeater1; protected System.Web.UI.WebControls.TextBox txtHotelName; protected System.Web.UI.WebControls.HyperLink lnkPrev; protected System.Web.UI.WebControls.HyperLink lnkNext; protected System.Web.UI.WebControls.HyperLink lnkFirst; protected System.Web.UI.WebControls.HyperLink lnkLast; protected System.Web.UI.WebControls.Label lblPageCount; protected System.Web.UI.WebControls.Label lblCurrentPage; protected System.Web.UI.WebControls.Button Button1; private void Page_Load(object sender, System.EventArgs e) { // 在此处放置用户代码以初始化页面 //GetRoomPriceRecords(txtHotelName.Text.ToString().Trim()); if(!Page.IsPostBack) { if(Session["hotelname"] != null) { GetRoomPriceRecords(Session["hotelname"].ToString()); } } } #region 根据酒店名称等条件查询出满足条件的记录 public void GetRoomPriceRecords(string hotelName) { string sql = ""; sql = "SELECT hotelid,cname,address,star FROM hotelinfo WHERE 1=1 " ; if(hotelName.ToString().Trim() != "") { sql += " and cname like '%" +hotelName+ "%'"; } sql += " order by hotelid "; DataSet ds = (DataSet)USDAL.USExecutor.ExecuteSQL(sql,typeof(DataSet)); PagedDataSource obj=new PagedDataSource(); obj.DataSource=ds.Tables[0].DefaultView; //以下为调用系统自带的DataPageSource分页类,并把PagedDataSource 对象赋给Repeater控件 obj.AllowPaging=true; obj.PageSize=20; int CurrentPage; if (Request.QueryString["Page"] == null) { CurrentPage=1; } else { CurrentPage=Convert.ToInt32(Request.QueryString["Page"]); } obj.CurrentPageIndex = CurrentPage-1; lblCurrentPage.Text = CurrentPage.ToString(); lblPageCount.Text = obj.PageCount.ToString(); //lblCurrentPage.Text = "当前第" + CurrentPage.ToString()+"页/共"+obj.PageCount.ToString()+"页"; if (!obj.IsFirstPage) { lnkPrev.NavigateUrl=Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurrentPage-1); lnkFirst.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(1); } else { lnkFirst.NavigateUrl = ""; } if (!obj.IsLastPage) { lnkNext.NavigateUrl=Request.CurrentExecutionFilePath+ "?Page=" + Convert.ToString(CurrentPage+1); lnkLast.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(obj.PageCount); } else { lnkLast.NavigateUrl = ""; } //以上为调用系统自带的DataPageSource分页类,并把PagedDataSource 对象赋给Repeater控件 Repeater1.DataSource=obj; Repeater1.DataBind(); } #endregion #region Web 窗体设计器生成的代码 override protected void OnInit(EventArgs e) { // // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。 // InitializeComponent(); base.OnInit(e); } /// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() { this.Button1.Click += new System.EventHandler(this.Button1_Click); this.Load += new System.EventHandler(this.Page_Load); } #endregion private void Button1_Click(object sender, System.EventArgs e) { Session["hotelname"] = txtHotelName.Text.ToString().Trim(); Response.Redirect("RoomPriceQuery.aspx"); } }} ajax TabContainer异步取数据 ACCESS除了使用自动编号类型去设置ID之外,如何设置唯一ID像MSSQL里{80964AD5-86DA-47AD-B338-8AA0A0F918FF}格式差不多的? js读取xml flash不显示 来者有分 asp.net打开.dbf文件的问题 求助:LionSky的HtmlEditor 3.1_Demo在线编辑器怎么使用? 验证控件的问题 asp.net 请教:如何在ASP.net中创建SQL数据库? 怎样移动服务器端的文件并保存到数据库?求指点一下 asp.net頁面timer控件怎麽用呢? 服务器控件能加上JAVASCRIPT事件吗?
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;namespace Top3Club.hotel
{
/// <summary>
/// RoomPriceQuery 的摘要说明。
/// </summary>
public class RoomPriceQuery: System.Web.UI.Page
{
protected System.Web.UI.WebControls.Repeater Repeater1;
protected System.Web.UI.WebControls.TextBox txtHotelName;
protected System.Web.UI.WebControls.HyperLink lnkPrev;
protected System.Web.UI.WebControls.HyperLink lnkNext;
protected System.Web.UI.WebControls.HyperLink lnkFirst;
protected System.Web.UI.WebControls.HyperLink lnkLast;
protected System.Web.UI.WebControls.Label lblPageCount;
protected System.Web.UI.WebControls.Label lblCurrentPage;
protected System.Web.UI.WebControls.Button Button1;
private void Page_Load(object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
//GetRoomPriceRecords(txtHotelName.Text.ToString().Trim());
if(!Page.IsPostBack)
{
if(Session["hotelname"] != null)
{
GetRoomPriceRecords(Session["hotelname"].ToString());
}
}
}
#region 根据酒店名称等条件查询出满足条件的记录
public void GetRoomPriceRecords(string hotelName)
{ string sql = "";
sql = "SELECT hotelid,cname,address,star FROM hotelinfo WHERE 1=1 " ;
if(hotelName.ToString().Trim() != "")
{
sql += " and cname like '%" +hotelName+ "%'";
}
sql += " order by hotelid ";
DataSet ds = (DataSet)USDAL.USExecutor.ExecuteSQL(sql,typeof(DataSet));
PagedDataSource obj=new PagedDataSource();
obj.DataSource=ds.Tables[0].DefaultView;
//以下为调用系统自带的DataPageSource分页类,并把PagedDataSource 对象赋给Repeater控件
obj.AllowPaging=true;
obj.PageSize=20;
int CurrentPage;
if (Request.QueryString["Page"] == null)
{
CurrentPage=1;
}
else
{
CurrentPage=Convert.ToInt32(Request.QueryString["Page"]);
}
obj.CurrentPageIndex = CurrentPage-1;
lblCurrentPage.Text = CurrentPage.ToString();
lblPageCount.Text = obj.PageCount.ToString();
//lblCurrentPage.Text = "当前第" + CurrentPage.ToString()+"页/共"+obj.PageCount.ToString()+"页";
if (!obj.IsFirstPage)
{
lnkPrev.NavigateUrl=Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurrentPage-1);
lnkFirst.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(1);
}
else
{
lnkFirst.NavigateUrl = "";
} if (!obj.IsLastPage)
{
lnkNext.NavigateUrl=Request.CurrentExecutionFilePath+ "?Page=" + Convert.ToString(CurrentPage+1);
lnkLast.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(obj.PageCount); }
else
{
lnkLast.NavigateUrl = "";
} //以上为调用系统自带的DataPageSource分页类,并把PagedDataSource 对象赋给Repeater控件
Repeater1.DataSource=obj;
Repeater1.DataBind();
}
#endregion
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.Button1.Click += new System.EventHandler(this.Button1_Click);
this.Load += new System.EventHandler(this.Page_Load); }
#endregion private void Button1_Click(object sender, System.EventArgs e)
{ Session["hotelname"] = txtHotelName.Text.ToString().Trim();
Response.Redirect("RoomPriceQuery.aspx");
}
}
}