product_buy.aspx.cs

基于VS05和SQL05做的一个电子商务网站

using System;
using System.Data;
using System.Configuration;
using System.Collections;
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;
using System.Configuration;


public partial class Product_buy : System.Web.UI.Page
{
    public static int TotalPage;//定义变量来保存总页数
    public int CurPage;//定义变量来保存当前页索引
    public int Tnum;//总条数;
    public int EachPage;//每页总条数
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["ConnStr"]);//调用Web.config连接数据库
            String sql = "SELECT * FROM Orders where BuyerId='" + Session["username"].ToString() + "'"; //数据库连接字符串
            /*
             SqlCommand command=new SqlCommand(sql,connection);//构件执行数据命令
            connection.Open();//打开数据库
            SqlDataReader dr=command.ExecuteReader();//保存从数据库里面返回的一条记录
            */
            SqlDataAdapter da = new SqlDataAdapter(sql, connection);
            DataSet ds = new DataSet();
            da.Fill(ds, "Table");
            PagedDataSource objPage = new PagedDataSource();//创建分页类
            objPage.DataSource = ds.Tables["Table"].DefaultView;//设置数据源

            objPage.AllowPaging = true;
            objPage.PageSize = 10;

            if (Request.QueryString["Page"] != null)
            {
                CurPage = Convert.ToInt32(Request.QueryString["Page"]);
                CurPage = Math.Min(CurPage, objPage.PageCount);
                CurPage = Math.Max(CurPage, 1);
            }
            else
                CurPage = 1;
            objPage.CurrentPageIndex = CurPage - 1;
            TotalPage = objPage.PageCount;
            Tnum = objPage.DataSourceCount;
            EachPage = objPage.Count;
            lblCurPage.Text = "第 " + CurPage.ToString() + " / " + TotalPage.ToString() + " 页";
            lblTnum.Text = "共: " + Tnum + " 条记录";
            lblEachPage.Text = "每页有: " + EachPage.ToString() + " 条记录";

            if (objPage.CurrentPageIndex != 0)
                lnkFirst.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(1);
            if (objPage.CurrentPageIndex != TotalPage - 1)
                lnkLast.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(TotalPage);

            if (!objPage.IsFirstPage)
                lnkPrev.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage - 1);
            if (!objPage.IsLastPage)
                lnkNext.NavigateUrl = Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(CurPage + 1);


            Repeater1.DataSource = objPage;
            Repeater1.DataBind();
        }
    }
    protected void btnPage_Click(object sender, EventArgs e)
    {
        int PageNum = 0;
        if (!Request.Form["txtPage"].Equals(""))
            PageNum = Convert.ToInt32(Request.Form["txtPage"]);
        if (PageNum <= 0 || PageNum > TotalPage)
            Response.Redirect(Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(1));
        else
            Response.Redirect(Request.CurrentExecutionFilePath + "?Page=" + Convert.ToString(PageNum));
    }
}