GridView手动在后台增加-删除(2)

3后台代码：

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 
{
    protected void Page_Load(object sender, EventArgs e)
    {
       //string conn = SqlHelper.SQLCONN;
       
       
       //try
       //{
       //    conn.Open();
       //    if (conn.State == ConnectionState.Open)
       //    {
       //        Response.Write("数据库连接成功！");
       //    }
       //}
       //catch (Exception ee)
       //{
       //    Response.Write(ee.Message);
       //}
       //finally {
       //    conn.Close();
       //}

        if (!IsPostBack)
        {
            dvDataBind();
        }

        
    }
    private void dvDataBind()
    {
        SqlConnection conn = new SqlConnection("server=.;database=cs;uid=sa;pwd=");
        SqlDataAdapter da = new SqlDataAdapter("select * from login_user", conn);
        DataSet ds = new DataSet();
        da.Fill(ds, "login_user");
        GridView1.DataSource = ds;
        GridView1.DataBind();
        GridView2.DataSource = ds;
        //GridView2.DataKeyNames = new String[] { "id" };
        GridView2.DataBind();
        conn.Close();
    }
    protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        SqlConnection conn = new SqlConnection("server=.;database=cs;uid=sa;pwd=");
        conn.Open();
        TextBox txt_temp_description = (TextBox)(GridView2.Rows[e.RowIndex].FindControl("textbox1"));
        string aa = txt_temp_description.Text;
        string UpdateStr = "update login_user set txtpassword='" + aa + "' where id='" + GridView2.DataKeys[e.RowIndex]["id"].ToString() + "'";
        SqlCommand UpdateCmd = new SqlCommand(UpdateStr, conn);
        UpdateCmd.ExecuteNonQuery();
        GridView2.EditIndex = -1;
        dvDataBind();

    }
    protected void GridView2_RowEditing(object sender, GridViewEditEventArgs e)
    {
        GridView2.EditIndex = e.NewEditIndex;
        this.dvDataBind();
    }
    protected void GridView2_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            LinkButton lnkBtn = (LinkButton)e.Row.FindControl("LinkButton4");
            if (lnkBtn != null)
            {
                lnkBtn.Attributes.Add("onclick", "return( confirm('您确认要删除此“即时业务类别”信息？') );");
            }
        }
    }
    protected void GridView2_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        SqlConnection conn = new SqlConnection("server=.;database=cs;uid=sa;pwd=");
        conn.Open();
        string DeleteStr = "DELETE FROM login_user WHERE id='" + GridView2.DataKeys[e.RowIndex]["id"].ToString() + "'";
        SqlCommand UpdateCmd = new SqlCommand(DeleteStr, conn);
        UpdateCmd.ExecuteNonQuery();
        dvDataBind();
        //Sql_string = "dele";
        //dvDataBind();
    }
    protected void GridView2_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView2.EditIndex = -1;
        dvDataBind();
    }
}

我标记的红色地方时需要你思考的！