SqlConnection conn2 = new SqlConnection((string)Application["sqlConnectionString"]);
conn2.Open();
string sql2 = "select FileName from BBS,Board where BoardName = '"+sel+"'";
SqlCommand cmd2 = new SqlCommand(sql2,conn2);
SqlDataReader reader2 = cmd2.ExecuteReader();
try
{
SqlCommand cmd;
string sql;
while(reader2.Read())
{
idxFileName = reader2["FileName"].ToString().Trim();
sql = "delete BBS where Board = '"+idxFileName+"'";
cmd = new SqlCommand(sql,conn2);
cmd.ExecuteNonQuery();
}
//cmd.Dispose();
}
catch
{
Response.Write("error in deleting bbs(filename) on database");
}
finally
{
reader2.Close();
cmd2.Dispose();
conn2.Close();
}现在要删除选定的filename 但是选出来的有多个filename 怎么来把这些一起删除
conn2.Open();
string sql2 = "select FileName from BBS,Board where BoardName = '"+sel+"'";
SqlCommand cmd2 = new SqlCommand(sql2,conn2);
SqlDataReader reader2 = cmd2.ExecuteReader();
try
{
SqlCommand cmd;
string sql;
while(reader2.Read())
{
idxFileName = reader2["FileName"].ToString().Trim();
sql = "delete BBS where Board = '"+idxFileName+"'";
cmd = new SqlCommand(sql,conn2);
cmd.ExecuteNonQuery();
}
//cmd.Dispose();
}
catch
{
Response.Write("error in deleting bbs(filename) on database");
}
finally
{
reader2.Close();
cmd2.Dispose();
conn2.Close();
}现在要删除选定的filename 但是选出来的有多个filename 怎么来把这些一起删除
解决方案 »
- asp.net MVC 模式中Model模型中一定要用Model2.edmx这种文件吗???
- mvc jquery.treeview有谁有个实际的例子吗、
- 获取客户端IP地址!
- 求一个简单的JS正则表达式 对的都有分
- 蛙蛙请教:关于OA里面的加密解密,数字信封,数字签名的问题
- asp.net PasswordRecovery控件问题 800天了 都没人解决~~~在线等!!
- saucer,attention please!how to write setup project for a large enterprise template project much like : "Duwamish"
- 怎样才能动态改变meta里的值?
- 如果要提取大量的数据放在客户端,而且,还要再用到这些数据,怎么保存合适?
- 十万火急:重装系统之后,为什么不能联接Sql数据库?且联接字符串都正确,就连以前做的东西也不能联了。
- asp.net 中listbox问题
- DataGrid 在自定义列里加弹出窗口,代码如何写?
我现在的方法是
SqlConnection conn2 = new SqlConnection((string)Application["sqlConnectionString"]);
conn2.Open();
//设置删除标记 把BBS(Status)中的Status设置为0
string sql2 = "update BBS set Status = '0' where FileName in (select FileName from BBS,Board where BoardName = '"+sel+"')";
SqlCommand cmd2 = new SqlCommand(sql2,conn2);
cmd2.ExecuteNonQuery();
try
{
string sql = "delete from BBS where Status = '0'";
SqlCommand cmd = new SqlCommand(sql,conn2);
cmd.ExecuteNonQuery();
cmd.Dispose();
}
现在就是需要用reader读出来的记录 如何删除
{
SqlCommand cmd;
string sql="";
while(reader2.Read())
{
sql+=","+reader2["FileName"].ToString().Trim();
}
if (sql!="")
{
string strCom = "delete BBS where Board in ("+sql.Remove(0,1)+")";
cmd = new SqlCommand(strCom ,conn2);
cmd.ExecuteNonQuery();
}
//cmd.Dispose();
}