Gridview后台代码

 protected void Page_Load(object sender, EventArgs e)
    {
        if (!Page.IsPostBack)
        {
            Getdata();
        }
    }
    public void Getdata()
    {
        GridView1.DataSource = SqlHelper.ExecuteDataset(SqlHelper.ConnectionStringMain, CommandType.Text, "select *from 雇员").Tables[0];
        GridView1.DataBind();

    }

    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView1.EditIndex = e.NewEditIndex;
        Getdata();
    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string id = GridView1.DataKeys[e.RowIndex].Value.ToString();
        SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringMain, CommandType.Text, "delete 雇员 where 雇员ID=" + id + "");
        Getdata();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string businiss = (GridView1.Rows[e.RowIndex].Cells[3].Controls[0] as TextBox).Text;
        string call = (GridView1.Rows[e.RowIndex].Cells[4].Controls[0] as TextBox).Text;
        string id = GridView1.DataKeys[e.RowIndex].Value.ToString();
        update(businiss, call, id);
        GridView1.EditIndex = -1;
        Getdata();
    }
    private void update(string businiss, string call, string id)
    {
        string sql="update 雇员 set 职务=@businiss,尊称=@Call where 雇员ID=@id";
        SqlParameter[] par = new SqlParameter[]
        {
            new SqlParameter("@businiss",businiss),
            new SqlParameter("@Call",call),
            new SqlParameter("@id",id)
        };
        SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringMain, CommandType.Text, sql, par);
    }
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;
        Getdata();

    }

转载于:https://www.cnblogs.com/ljb8664/archive/2008/08/27/Gridview.html