gridview中关于删除和编辑行

删除的cs代码： protected void Page_Load(object sender, EventArgs e)
    {
        bind();
    }
    public void bind()
    {
        SqlConnection con = new SqlConnection(@"Data Source=PC-200903122150 /SQLEXPRESS;InitialCatalog=LoginTest;Integrated Security=True;Pooling=False");
        con.Open();
        SqlCommand cmd = new SqlCommand("select * from Login", con);
        SqlDataReader sdr = cmd.ExecuteReader();
       
        GridView1.DataSource = sdr;
        GridView1.DataKeyNames = new string[] { "userName" };
        GridView1.DataBind();
       
    }
   
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        SqlConnection con = new SqlConnection(@"Data Source=PC-200903122150/SQLEXPRESS;Initial Catalog=LoginTest;Integrated Security=True;Pooling=False");
        con.Open();
        string keys = GridView1.DataKeys[e.RowIndex].Value.ToString();;
        string sql = "delete  from Login where userName='" + keys + "'";
        SqlCommand cmd = new SqlCommand(sql, con);
        cmd.ExecuteScalar();
        bind();
    }

 

编辑的cs代码：

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
           bind();
        }
       
    }
    public void bind()
    {
        SqlConnection con = new SqlConnection(@"Data Source=PC-200903122150/SQLEXPRESS;Initial Catalog=LoginTest;Integrated Security=True;Pooling=False");
        con.Open();
        SqlCommand cmd = new SqlCommand("select * from Login", con);
        SqlDataReader sdr = cmd.ExecuteReader();

        GridView1.DataSource = sdr;
        GridView1.DataKeyNames = new string[] { "userName" };
        GridView1.DataBind();
        con.Close();

    }
    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)
    {
       
        GridView1.EditIndex = e.NewEditIndex;//把GridView改为可编辑的状态
        bind();
    }
   
    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)
    {
        GridView1.EditIndex = -1;//取消编辑
         bind();
    }
    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        SqlConnection con = new SqlConnection(@"Data Source=PC-200903122150/SQLEXPRESS;Initial Catalog=LoginTest;Integrated Security=True;Pooling=False");
        con.Open();
        string keys = GridView1.DataKeys[e.RowIndex].Value.ToString();
        string userPwd = ((TextBox)(GridView1.Rows[e.RowIndex].Cells[1].Controls[0])).Text.ToString();
        string sql = "update Login set   userPwd='" + userPwd + "' where userName='"+keys+"'";
        SqlCommand cmd = new SqlCommand(sql, con);
        cmd.ExecuteNonQuery();
        GridView1.EditIndex = -1;
        bind();
    }

 

源码和数据库奉上jerryzhang.javaey.com！！！