(关于.net)GridView删除行

来源:百度知道 编辑:UC知道 时间:2024/05/16 01:30:11
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
}
方法该怎样写?

通常在WEB页面中不用这个事件!
例如要删除某一行时,通常先对数据库操作删除先,再绑定一下GRIDVIEW!这样就达到了删除效果!

string id = GridView1.DataKeys[e.RowIndex].Value.ToString();
sqlstr = "delete from 表名 where id=" + id + "";
SqlConnection con = new SqlConnection(SqlConStr);
SqlCommand cmd = new SqlCommand(sqlstr, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();

形如:
protected void gvMessage_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string userid = gvMessage.DataKeys[e.RowIndex].Value.ToString();
using (SqlConnection conn = DBAccess.getSqlConnection())
{
SqlCommand comm = new SqlCommand("delete SiteMailing where ID='" + userid + "'", conn);
SqlCommand comm2 = new SqlCommand("delete Message where ID='" + userid + "'", conn);
try
{
comm.ExecuteN