为什么我写的这段代码就是删不了数据库中的数据呢?些运行后也不会跳转到title.aspx这个页面,还请各位帮忙看看
try
{
string titleID=Request.QueryString["ID"];
SqlConnection zjsqlConnection=new SqlConnection(strconnection);
string delecttitleText="delect from BBSTitle where ID='"+Int32.Parse(titleID)+"'";
string delectbackText="delect from back where parent_id='"+Int32.Parse(titleID)+"'";
SqlCommand zjdelCommand=new SqlCommand();
zjsqlConnection.Open();
zjdelCommand.Connection=zjsqlConnection;
zjdelCommand.CommandText=delecttitleText;
zjdelCommand.ExecuteNonQuery();
zjsqlConnection.Close();
zjsqlConnection.Open();
zjdelCommand.Connection=zjsqlConnection;
zjdelCommand.CommandText=delectbackText;
zjdelCommand.ExecuteNonQuery();
zjdelCommand=null;
Response.Redirect("title.aspx");
}
catch(Exception exp)
{
Response.Write(exp.Message);
}
try
{
string titleID=Request.QueryString["ID"];
SqlConnection zjsqlConnection=new SqlConnection(strconnection);
string delecttitleText="delect from BBSTitle where ID='"+Int32.Parse(titleID)+"'";
string delectbackText="delect from back where parent_id='"+Int32.Parse(titleID)+"'";
SqlCommand zjdelCommand=new SqlCommand();
zjsqlConnection.Open();
zjdelCommand.Connection=zjsqlConnection;
zjdelCommand.CommandText=delecttitleText;
zjdelCommand.ExecuteNonQuery();
zjsqlConnection.Close();
zjsqlConnection.Open();
zjdelCommand.Connection=zjsqlConnection;
zjdelCommand.CommandText=delectbackText;
zjdelCommand.ExecuteNonQuery();
zjdelCommand=null;
Response.Redirect("title.aspx");
}
catch(Exception exp)
{
Response.Write(exp.Message);
}
string delectbackText="delect from back where parent_id='"+Int32.Parse(titleID)+"'";没有细看,你这两处用格式化字符串写不行吗?string delecttitleText=string.format("delect from BBSTitle where ID={0}",Int32.Parse(titleID));
string delectbackText=string.format("delect from back where parent_id={0}",Int32.Parse(titleID));另外,你的SqlCommand 的类型为什么没有指定!
zjdelCommand.CommandType = CommandType.Text
两次执行,都没有指定!
string delectbackText="delect from back where parent_id='"+titleID+"'";
fredlin说的,删除事没有注册是啥意思》?
唉,还是不行啊!
fredlin说的,删除事没有注册是啥意思》?
---------------
2,以前我试过将一个按钮改名后,.cs文件中的原来那个名称click事件直接改了用.好像就不行.button_click -->改为 btnDel_click 大概这个意思.