index.aspx.cs

数据绑定采用GridView控件

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.OleDb;
using System.Net;
public partial class _Default : System.Web.UI.Page 
{
   
    OleDbConnection conn = new OleDbConnection(ConfigurationManager.ConnectionStrings["con"].ConnectionString);
    //int ToatalCountRecord;//总记录数
    //int PageItem = 5;//每页显示的条数
    //int CurrentPage = 1;//当前页数
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!this.Page.IsPostBack)
        {
            this.ShowInfo();
            //if (Request.QueryString["page"] != null)
            //{
            //    if (!Int32.TryParse(Request.QueryString["page"].ToString(), out CurrentPage))
            //    {
            //        Response.Write("请输入分页参数!");
            //        Response.End();
            //        return;
            //    }
            //}
           
           // this.BuidGrid();
        }
    }
    private void ShowInfo() 
    {
        string hideid = "1";
        string s2 = "select * from message  where hideid=" + hideid + " order by addtime,orderid desc ";
        OleDbDataAdapter da = new OleDbDataAdapter(s2,conn);
        DataSet ds = new DataSet();
        da.Fill(ds,"a");
        this.GridView1.DataSource = ds.Tables["a"].DefaultView;
        this.GridView1.DataKeyNames = new string[] { "id" };
        this.GridView1.DataBind();
    }
    //private void BuidGrid()
    //{
    //    string hideid = "1";
    //    string s2 = "select * from message  where hideid="+hideid+" order by orderid,addtime desc ";
    //    OleDbDataAdapter da = new OleDbDataAdapter(s2, conn);
    //    DataSet ds = new DataSet();
    //    int startRecord = (CurrentPage - 1) * PageItem;
    //    da.Fill(ds, startRecord, PageItem, "b");
    //    this.DataList1.DataSource = ds.Tables["b"].DefaultView;
    //    this.DataList1.DataBind();
    //    OleDbCommand comm = new OleDbCommand("select count(*) from message", conn);
    //    conn.Open();
    //    ToatalCountRecord = Convert.ToInt32(comm.ExecuteScalar());
    //    conn.Close();
    //   // BuildPages();
    //}
    
//    private void BuildPages()
//    {
//        int Step = 5;//偏移量
//        int LeftNum = 0;
//        int RightNum = 0;
//        string PageUrl = Request.CurrentExecutionFilePath;
//;
//        int PageCount = (int)Math.Ceiling((double)(ToatalCountRecord) / PageItem);
//        if (CurrentPage - Step < 1)
//        {
//            LeftNum = 1;
//        }
//        else
//        {
//            LeftNum = CurrentPage - Step;
//        }

//        if (CurrentPage + Step > PageCount)
//        {
//            RightNum = PageCount;
//        }
//        else
//        {
//            RightNum = CurrentPage + Step;
//        }

//        //string OutPut = "";
//        //if (CurrentPage > 1)
//        //{
//        //    //OutPut += "<a href='" + PageUrl + "?page=" + (CurrentPage - 1) + "'>" + "上一页" + "</a>";
//        //    //this.FirstPage.Enabled = true;

//        //}
//        //this.FirstPage.NavigateUrl = PageUrl + "?page=" + 1;
//        //this.PrePage.NavigateUrl =PageUrl + "?page=" + (CurrentPage - 1);
//        //this.NextPage.NavigateUrl=PageUrl + "?page=" + (CurrentPage + 1);
//        //this.LastPage.NavigateUrl = PageUrl + "?page=" + PageCount;
      
//        //for (int i = LeftNum; i <= RightNum; i++)
//        //{
//        //    if (i == CurrentPage)
//        //    {
//        //        OutPut += "<font color=red>"  + "[" + i.ToString() + "]" + "</font>";
              
//        //    }
//        //    else
//        //    {
//        //        OutPut += "<a href='" + PageUrl + "?page=" + i.ToString() + "'>"  + "[" + i.ToString() + "]" + "</a>";
               
//        //    }
//        //}

//        //if (CurrentPage >= PageCount)
//        //{
//        //    //OutPut += "<a href='" + PageUrl + "?page=" + (CurrentPage + 1) + "'>" + "下一页" + "</a>";     
//        //    this.NextPage.Enabled = false;
//        //}
     
//        //this.PageInfo.InnerHtml = OutPut;
      
      
//    }
    protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
    {
        Response.Redirect("message.aspx");
    }


    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.GridView1.PageIndex = e.NewPageIndex;
        this.ShowInfo();
    }
}