|
#2
雪雨星风2008-06-13 17:58
我放了个复选框 还有另外的两个按钮 1个全选 1个删除 和QQ邮箱差不多的效果 我用以下方法删除选中项 还是提示
 for (int i = 0; i < gvUser.Rows.Count;i++ ) { //string userID = ""; if(((CheckBox)gvUser.Rows[i].FindControl("ckOne")).Checked==true) { int id =Convert.ToInt32(gvUser.Rows[i].Cells[13].Text); //userID = this.gvUser.DataKeys[.DataItemIndex].Value.ToString(); //Response.Write(str); string sqlconnstr = ConfigurationManager.AppSettings["ConnStr"].ToString(); SqlConnection conn = new SqlConnection(sqlconnstr); SqlCommand comm = new SqlCommand("delete from Stu_Info where userID=" + id, conn); conn.Open(); Response.Write("<script language=javascript>window.alert('确定要删除选定的内容吗?')</script>"); comm.ExecuteNonQuery(); chaxun(); conn.Close(); } } |
极度郁闷中，困扰了一天了，做了4遍，结果还是一个样，紧急求救！！！！
string strCon = "Data Source=(local);Database=baoming;Uid=sa;Pwd=admin";
SqlConnection sqlcon;
SqlCommand sqlcom;
protected void gvUser_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string sqlstr = "delete from Stu_Info where userID='" + gvUser.DataKeys[e.RowIndex].Value.ToString() + "'";
sqlcon = new SqlConnection(strCon);
sqlcom = new SqlCommand(sqlstr, sqlcon);
sqlcon.Open();
sqlcom.ExecuteNonQuery();
sqlcon.Close();
bind();
}
public void bind()
{
string sqlstr = "select * from Stu_Info";
sqlcon = new SqlConnection(strCon);
SqlDataAdapter myda = new SqlDataAdapter(sqlstr, sqlcon);
DataSet myds = new DataSet();
sqlcon.Open();
myda.Fill(myds, "Stu_Info");
gvUser.DataSource = myds;
gvUser.DataKeyNames = new string[] { "userID" };//主键
gvUser.DataBind();
sqlcon.Close();
}
