gridview手动分页

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            GridViewDataBind();
        }

    }
    public void GridViewDataBind()
    {
        Button1.Enabled = true;
        Button2.Enabled = true;
        SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ToString());
        try
        {
            conn.Open();
            SqlDataAdapter sa = new SqlDataAdapter("select * from customers where 1=1", conn);
            DataSet ds = new DataSet();
            sa.Fill(ds, "customers");
            if (ds.Tables[0].Rows.Count == 0)
            {
                AddDummyData(ds);
            }
            GridView1.DataSource = ds.Tables["customers"];
            GridView1.AllowPaging = true;
            GridView1.PageSize = 5;
            GridView1.DataBind();
            conn.Close();
            if (GridView1.PageIndex == 0)
            {
                Button1.Enabled = false;
            }
            if (GridView1.PageIndex == GridView1.PageCount - 1)
            {
                Button2.Enabled = false;
            }

        }
        catch
        {

        }
        finally
        {
            conn.Close();
        }
    }
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex = e.NewPageIndex;
        GridViewDataBind();
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        GridView1.PageIndex = GridView1.PageIndex - 1;
        GridViewDataBind();
    }
    protected void Button2_Click(object sender, EventArgs e)
    {
        GridView1.PageIndex = GridView1.PageIndex + 1;
        GridViewDataBind();
    }
    protected void Button3_Click(object sender, EventArgs e)
    {
        GridView1.PageIndex = GridView1.PageCount - 1;
        GridViewDataBind();
    }
    protected void Button4_Click(object sender, EventArgs e)
    {
        GridView1.PageIndex = 0;
        GridViewDataBind();
    }

//没有任何数据显示标头

    private void AddDummyData(DataSet ds)
    {

        // Add a dummy row

        DataTable dt = ds.Tables[0];

        DataRow newRow = dt.NewRow();

        dt.Rows.Add(newRow);

    }

//隐藏分页

//gridview有一个属性【PageSettings】的子属性【Visible】设置成【False】
 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值