gridview 编辑需要写的事件》。。。。_mygridview repositoryitemtextedit事件-优快云博客

本文链接：https://blog.youkuaiyun.com/kk5595/article/details/5253630

本文介绍了一个使用ASP.NET中GridView控件进行数据编辑和更新的实例。具体展示了如何通过RowEditing、RowUpdating和RowCancelingEdit事件来实现数据的编辑流程，并使用ADO.NET进行数据库操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

protected void GridView1_RowEditing( object sender, GridViewEditEventArgs e)
... {
GridView1.EditIndex = e.NewEditIndex;
bind();
}
protected void GridView1_RowUpdating( object sender, GridViewUpdateEventArgs e)
... {
        sqlcon = new SqlConnection(strCon);
string sqlstr = " update tb_Member set name=' "
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[ 1 ].Controls[ 0 ])).Text.ToString().Trim() + " ',sex=' "
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[ 2 ].Controls[ 0 ])).Text.ToString().Trim() + " ',nPlace=' "
+ ((TextBox)(GridView1.Rows[e.RowIndex].Cells[ 3 ].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 tb_Member " ;
        sqlcon = new SqlConnection(strCon);
        SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
        DataSet myds = new DataSet();
        sqlcon.Open();
        myda.Fill(myds, " tb_Member " );
        GridView1.DataSource = myds;
        GridView1.DataKeyNames = new string [] ... { " id " } ;
        GridView1.DataBind();
        sqlcon.Close();
    }