我的asp.net里的删除代码如下:
protected void btndelete_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=.;database=jsj;uid=sa;pwd=;");
con.Open();
DateTime today1 = Convert.ToDateTime(Label1.Text); string str1 = "select count(*) from Orders where Shborrow < '" + today1 + "'and DBname='"+DropDownList1 .SelectedItem +"'";//删除应借日期小于系统当前日期的
SqlCommand cmd1 = new SqlCommand(str1, con);
cmd1 .ExecuteScalar (); int count1 = Convert.ToInt32(cmd1.ExecuteScalar()); if (count1> 0)
{
con.Close();
con.Open();
string str2 = "delete from Orders where Shborrow < '" + today1 + "' and DBname='"+DropDownList1 .SelectedItem +"'";//删除应借日期小于系统当前日期的
SqlCommand cmd2 = new SqlCommand(str2, con);
cmd2 .ExecuteNonQuery ();
// this.btndelete.Attributes.Add("onclick", "return confirm('您确定要删除这些记录吗?')");
Response.Write("<script>alert('删除成功!');</script>");
con.Close();
}
else
{
Response.Write("<script>alert('无超期记录!');</script>");
} con.Close(); }
protected void btndelete_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("server=.;database=jsj;uid=sa;pwd=;");
con.Open();
DateTime today1 = Convert.ToDateTime(Label1.Text); string str1 = "select count(*) from Orders where Shborrow < '" + today1 + "'and DBname='"+DropDownList1 .SelectedItem +"'";//删除应借日期小于系统当前日期的
SqlCommand cmd1 = new SqlCommand(str1, con);
cmd1 .ExecuteScalar (); int count1 = Convert.ToInt32(cmd1.ExecuteScalar()); if (count1> 0)
{
con.Close();
con.Open();
string str2 = "delete from Orders where Shborrow < '" + today1 + "' and DBname='"+DropDownList1 .SelectedItem +"'";//删除应借日期小于系统当前日期的
SqlCommand cmd2 = new SqlCommand(str2, con);
cmd2 .ExecuteNonQuery ();
// this.btndelete.Attributes.Add("onclick", "return confirm('您确定要删除这些记录吗?')");
Response.Write("<script>alert('删除成功!');</script>");
con.Close();
}
else
{
Response.Write("<script>alert('无超期记录!');</script>");
} con.Close(); }
解决方案 »
- 0-9数字生成8位随机码,生成多个时不要重复
- asp.net 打开一个新页面 求救
- guid datetime ,string 等等,你们一般如何初始化
- dataview做gridview数据源的问题
- 请教如何生成(vs2005)安装文件?
- 比如说一个聊天室,用来呈现文字的是一个div,那如何让其里面的滚动条永远在最下方也就是显示出最新的信息呢?解决后立刻结帖!
- 用户控件如何应用样式表
- 求楼长oa,帮忙发过来谢谢,[email protected]!
- 初学ASP.net 如何配置运行调试环境
- 序列化ICollection 遇到的问题,求解
- asp.net图片盗链时加水印问题
- 每页都要写session判断吗?
http://www.cndw.com/tech/net/200602153895.asp