GridView大全

  protected void GridView2_RowEditing(object sender, GridViewEditEventArgs e)
    {

        this.GridView2.EditIndex = e.NewEditIndex;
        this.BindToGridView_vipinfo();
    }
    protected void GridView2_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        this.GridView2.EditIndex = -1;
        this.BindToGridView_vipinfo();
    }
    protected void GridView2_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        //Response.Write(this.GridView2.DataKeys[e.RowIndex].Value.ToString());
        string sqlstr = "delete from reg where reg_id='" +Convert.ToInt32( this.GridView2.DataKeys[e.RowIndex].Value) + "'";

        SqlConnection conn = DB.CreationConnection();
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = conn;
        cmd.CommandText = sqlstr;
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();
        GridView2.EditIndex = -1;
        this.BindToGridView_vipinfo();
    }
    protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string sid = this.GridView2.DataKeys[e.RowIndex].Value.ToString();
        SqlConnection conn = DB.CreationConnection();
        string sqlstr = "update reg set reg_username='"
            + ((TextBox)(GridView2.Rows[e.RowIndex].Cells[0].Controls[0])).Text.ToString().Trim() + "',reg_pwd='"
            + ((TextBox)(GridView2.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString().Trim() + "'where reg_id='" + sid + "'";
        SqlCommand cmd = new SqlCommand();
        cmd.Connection = conn;
        cmd.CommandText = sqlstr;
        //omd = new OleDbCommand(sqlstr, conn);
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();
        GridView2.EditIndex = -1;
        this.BindToGridView_vipinfo();
    }