我的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();    }