protected void List_DeleteCommand(object source, DataListCommandEventArgs e)
{ string bid = e.CommandArgument.ToString();
string str = "Delete From A Where AId=(select AId from B where BId='"+bid+"')";
string str1="delete from C where CId='"+bid+"'";
string str2 = "delete from Bwhere BId='" + bid + "'";
SqlConnection myCon = new SqlConnection(ConfigurationManager.ConnectionStrings["mysql"].ConnectionString);
myCon.Open();
SqlCommand myCmd = new SqlCommand(str, myCon);
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("VideoId", vid);
myCmd.Parameters.Add(p[0]);
myCmd.ExecuteNonQuery();
myCmd.Parameters.Clear();
myCon.Close();
}
同时要删除三个表,A、B、C
Aid是B表里的一个字段,,
BId和CId相同
应该怎么写,,谢谢,,
{ string bid = e.CommandArgument.ToString();
string str = "Delete From A Where AId=(select AId from B where BId='"+bid+"')";
string str1="delete from C where CId='"+bid+"'";
string str2 = "delete from Bwhere BId='" + bid + "'";
SqlConnection myCon = new SqlConnection(ConfigurationManager.ConnectionStrings["mysql"].ConnectionString);
myCon.Open();
SqlCommand myCmd = new SqlCommand(str, myCon);
SqlParameter[] p = new SqlParameter[1];
p[0] = new SqlParameter("VideoId", vid);
myCmd.Parameters.Add(p[0]);
myCmd.ExecuteNonQuery();
myCmd.Parameters.Clear();
myCon.Close();
}
同时要删除三个表,A、B、C
Aid是B表里的一个字段,,
BId和CId相同
应该怎么写,,谢谢,,
--------------------------------------------------------------
程序,犹如人生。