【www.gdgbn.com--js教程】
private void Query()
{
Database db = new Database();
DataTable dataTable = db.GetDataTable("select top 10 * from table where ProductsNO like "BA01%"");
this.DataListtp.DataSource = dataTable;
this.DataBind();
PagedDataSource objPds = new PagedDataSource();
objPds.DataSource = ds.Tables[0].DefaultView;
objPds.AllowPaging = true;
objPds.PageSize = 15;
int CurPage;
int PageCount = ds.Tables[0].Rows.Count / objPds.PageSize;
if (ds.Tables[0].Rows.Count % objPds.PageSize > 0)
{
PageCount++;
}
if (Request.QueryString["Page"] != null)
CurPage = Convert.ToInt32(Request.QueryString["Page"]);
else
CurPage = 1;
objPds.CurrentPageIndex = CurPage - 1;
this.Label1.Text = "第" + CurPage.ToString() + "页 共" + PageCount.ToString() + "页";
if (!objPds.IsFirstPage)
{
lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString((CurPage - 1));
}
else
{
lnkPrev.EnableViewState = false;
}
if (!objPds.IsLastPage)
{
lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);
}
else
{
lnkNext.EnableViewState = false;
}
}
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;//引用SqlClicent类
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
this.DataBind();
}
private override void DataBind()
{
string constr = "server=local;uid=sa;pwd=;DataBase=**";
SqlConnection con = new SqlConnection(constr);//连接数据库
string sqlstr = "select * from table";
SqlDataAdapter sda = new SqlDataAdapter(sqlstr,con);
DataSet ds=new DataSet();
sda.Fill(ds);//填充数据集
DataList1.DataSource = ds;
DataList1.DataBind();
}
}