default.aspx.cs

gridview的使用大全,包括所有常见的功能 开发环境为asp.net2.0

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;

public partial class _Default : System.Web.UI.Page 
{
    SqlConnection sqlcon;

    SqlCommand sqlcom;

    string strCon = "Data Source=(local);Database=test;Uid=sa;";

    protected void Page_Load(object sender, EventArgs e)

    {

        if (!IsPostBack)

        {
            btnFirst.Enabled = false;
            btnPro.Enabled = false;
            bind();
            

        }

    }

    //编辑当前选重的记录
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        
            GridView1.EditIndex = e.NewEditIndex;
            
            bind();

    }

    //删除一行
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
         string sqlstr = "delete from mytable where ID= '"+ GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";
        sqlcon = new SqlConnection(strCon);

        sqlcom = new SqlCommand(sqlstr,sqlcon);

        sqlcon.Open();

        sqlcom.ExecuteNonQuery();

        sqlcon.Close();

        bind();


    }

    //更新数据
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        sqlcon = new SqlConnection(strCon);

        string sqlstr = "update mytable set userID='"

            + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[2].Controls[0])).Text.ToString().Trim() + "' where  ID='"

            + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

        sqlcom=new SqlCommand(sqlstr,sqlcon);

        sqlcon.Open();

        sqlcom.ExecuteNonQuery();

        sqlcon.Close();

        GridView1.EditIndex = -1;

        bind();


    }

    //取消编辑
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;

        bind();
    }


    //绑定数据源
    public void bind()
    {

        string sqlstr = "select * from mytable";

        sqlcon = new SqlConnection(strCon);

        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);

        DataSet myds = new DataSet();

        sqlcon.Open();

        myda.Fill(myds, "mytable");

        GridView1.DataSource = myds;

        GridView1.DataKeyNames = new string[] { "id" };//主键

        GridView1.DataBind();
        sqlcon.Close();
        int iPage=GridView1.PageIndex+1;
        Label2.Text = "当前页数:" + iPage + "/" + GridView1.PageCount.ToString() + "共" + GridView1.PageCount.ToString() + "页";

    }

    //实现分页
    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GridView1.PageIndex= e.NewPageIndex;
        bind();
    }

    //首页
    protected void Button1_Click(object sender, EventArgs e)
    {
       
         
            btnFirst.Enabled = false;
            btnPro.Enabled = false;
            btnMove.Enabled = true;
            btnLast.Enabled = true;
            GridView1.PageIndex = 0;
            bind();
    }

    //上一页
    protected void Button4_Click(object sender, EventArgs e)
    {
        
          
            GridView1.PageIndex = GridView1.PageIndex - 1;
            bind();
            if (GridView1.PageIndex ==0)
            {
             btnFirst.Enabled = false;
            btnPro.Enabled = false;
            btnMove.Enabled = true;
            btnLast.Enabled = true;
            }

    }

    //下一页
    protected void Button3_Click(object sender, EventArgs e)
    {
            GridView1.PageIndex = GridView1.PageIndex+ 1;
            bind();
            if (GridView1.PageIndex ==GridView1.PageCount - 1)
            {
                btnFirst.Enabled = true;
                btnPro.Enabled = true;
                btnMove.Enabled = false;
                btnLast.Enabled = false;
            }
    }

    //最后一页
    protected void Button2_Click(object sender, EventArgs e)
    {
       
    
            btnMove.Enabled = false;
            btnLast.Enabled = false;
            btnFirst.Enabled = true;
            btnPro.Enabled = true;
            GridView1.PageIndex = GridView1.PageCount - 1;
            bind();
    }

    //全选
    protected void cbxAll_CheckedChanged(object sender, EventArgs e)
    {
         for (int i = 0; i < this.GridView1.Rows.Count; i++)

          {

              ((CheckBox)GridView1.Rows[i].FindControl("cbx")).Checked =this.cbxAll.Checked;

          }
          btnDelALL.Enabled = true;
          btnDelALL.Visible = true;

    }

    //批量删除
    protected void btnDelALL_Click(object sender, EventArgs e)
    {
          bool iflag = false;
          for (int i = 0; i < this.GridView1.Rows.Count; i++)
          {
              string strid = GridView1.Rows[i].Cells[1].Text;
              bool isChecked = ((CheckBox)GridView1.Rows[i].FindControl("cbx")).Checked;
              if (isChecked)
              {
                  iflag = true;
                  string sqlstr = "delete from mytable where ID= '" + strid + "'";
                  sqlcon = new SqlConnection(strCon);

                  sqlcom = new SqlCommand(sqlstr, sqlcon);

                  sqlcon.Open();

                  sqlcom.ExecuteNonQuery();

                  sqlcon.Close();

              }
          }
          if (iflag)
          {
              this.cbxAll.Checked = false;
              btnDelALL.Enabled = false;
              btnDelALL.Visible = false;

              bind();
          }
          else
          {
              Response.Write("<script language=javascript >alert('请选择要删除的记录');</script>");
          }
    }
    //重置
    protected void btnReset_Click(object sender, EventArgs e)
    {
        Response.Redirect("~/Default.aspx");

    }
    protected void btnAdd_Click(object sender, EventArgs e)
    {
        sqlcon = new SqlConnection(strCon);

        string sqlstr = "insert into  mytable ( userID)  values('" + txtName.Text + "')";

        sqlcom = new SqlCommand(sqlstr, sqlcon);

        sqlcon.Open();

        sqlcom.ExecuteNonQuery();

        sqlcon.Close();

        bind();
    }
}