请问各位大虾:为什么我这段代码不能删除数据呢??请指教谢谢!!!
是不是我的删除语句有问题呀?
string stuid;
stuid = delete1.delstuid.Text;
SqlConnection yzCon = new SqlConnection(yzconn);
yzCon.Open();
SqlTransaction myTrans = yzCon.BeginTransaction();//开始数据库出发事物
SqlCommand yzCom = new SqlCommand("",yzCon);
yzCom.Transaction = myTrans;
//定义SQL删除语句
yzCom.CommandText = "DELETE FROM stutable WHERE" + "学号=" + stuid;
//执行删除语句
yzCom.ExecuteNonQuery();
myTrans.Commit();//提交事务
yzCon.Close();
是不是我的删除语句有问题呀?
string stuid;
stuid = delete1.delstuid.Text;
SqlConnection yzCon = new SqlConnection(yzconn);
yzCon.Open();
SqlTransaction myTrans = yzCon.BeginTransaction();//开始数据库出发事物
SqlCommand yzCom = new SqlCommand("",yzCon);
yzCom.Transaction = myTrans;
//定义SQL删除语句
yzCom.CommandText = "DELETE FROM stutable WHERE" + "学号=" + stuid;
//执行删除语句
yzCom.ExecuteNonQuery();
myTrans.Commit();//提交事务
yzCon.Close();
"delete from stutable where 学号='"+stuid+"'"试一下
正解