分页.txt

学习积累的代码段

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;

public partial class uc_nootbook : System.Web.UI.UserControl
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {

            bind(); //调用数据绑定方法

            
        }
       
    }
    private void bind()//数据绑定方法
    {
        SqlConnection con = db.ceratcon();
        con.Open();
        SqlDataAdapter sdr = new SqlDataAdapter("select  * from Nootbook ", con);
        DataSet ds = new DataSet();
        sdr.Fill(ds, "Nootbook");
        this.GridView1.DataSource = ds.Tables["Nootbook"].DefaultView;
        
        this.GridView1.AllowPaging = true;
        this.GridView1.PageSize =20;//设置分页大小　／／要先设置分页后绑定数据不然分页不起作用哈哈
          this.GridView1.DataBind();

        if (this.GridView1.PageIndex == 0)
        {
            this.LinkButton3.Enabled = false;
            this.LinkButton4.Enabled = false;

        }
        else
        {
            this.LinkButton3.Enabled = true;
            LinkButton4.Enabled = true;

        }


        if (GridView1.PageIndex == GridView1.PageCount - 1)
        {
            this.LinkButton1.Enabled = false;
            this.LinkButton2.Enabled = false;

        }
        else
        {
            this.LinkButton1.Enabled = true;
            LinkButton2.Enabled = true;
        }


        con.Close();
          
    
    }
   
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {

    }
    protected void GridView1_RowCreated(object sender, GridViewRowEventArgs e)
    {
        e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#0099ff'");
        e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c;");

    }
    protected void LinkButton4_Click(object sender, EventArgs e)//必须设置四个按扭的clink事件都是一样的
    {
        //判断选择了哪个按扭
        switch(((LinkButton)sender).CommandArgument.ToString())
        {
            case "first":
                GridView1.PageIndex = 0;
                break;
            case "pry":
                GridView1.PageIndex = GridView1.PageIndex - 1;
                break;
            case "next":
                GridView1.PageIndex = GridView1.PageIndex + 1;
                break;
            case "last":
                GridView1.PageIndex = GridView1.PageCount - 1;
                break;
        
        
        }
        bind();//重新绑定数据
    }
}