两个文本框TextBox1、TextBox2中输入日期(格式为yyyy-mm-dd),sql语句中需查询满足两个时间段内的所有记录 ,以下语句如何修改才对
string time1 = TextBox1.Text;
string time2 = TextBox1.Text;
DateTime dt1 = Convert.ToDateTime(time1);
DateTime dt2 = Convert.ToDateTime(time2);
sql=select * from aa where 日期 between dt1 and dt2
string time1 = TextBox1.Text;
string time2 = TextBox1.Text;
DateTime dt1 = Convert.ToDateTime(time1);
DateTime dt2 = Convert.ToDateTime(time2);
sql=select * from aa where 日期 between dt1 and dt2
and DATE_FORMAT(日期,'%Y-%m-%d')<=DATE_FORMAT('" + dt2+ "','%Y-%m-%d')
string time2 = TextBox1.Text;
//DateTime dt1 = Convert.ToDateTime(time1);
//DateTime dt2 = Convert.ToDateTime(time2);
string sql="select * from aa where convert(varchar(10),日期,120) between dt1 and dt2";
string time2 = TextBox1.Text;
//DateTime dt1 = Convert.ToDateTime(time1);
//DateTime dt2 = Convert.ToDateTime(time2);
string sql="select * from aa where convert(varchar(10),日期,120) between dt1 and dt2";
http://cache.baidu.com/c?m=9f65cb4a8c8507ed4fece76310508a24420597634b86914323c3933fcf331d5c017be3b925231203d0c7616406b24a59eef73472351420c0c18ed714c9fecf68798766772e0b8630538459eb9c0632c151872be3b86fe0ad813684d8a1c4de2444ba50120b8ae7fb2c1765be&p=ce759a46d0801efc57eccb261607&user=baidu
string time1 = TextBox1.Text;
string time2 = TextBox2.Text;
//DateTime dt1 = Convert.ToDateTime(test1);
//DateTime dt2 = Convert.ToDateTime(test2);
SqlConnection cn = new SqlConnection(strConn); cn.Open();
string insertstr= "delete from ruku1 where convert(varchar(10),rukutime,120) between time1 and time2 "; SqlCommand cmd = new SqlCommand(insertstr, cn);
try
{
cmd.ExecuteNonQuery();
}
catch (MembershipCreateUserException ex) //捕捉异常
{
Response.Write("<script>alert('导入内容:" + ex.Message + "')</script>");
}
Response.Write("<script>alert('删除成功!');location='default.aspx'</script>");
cn.Close();
delete from ruku1 where convert(varchar(10),rukutime,120) between "+time1+" and "+time2 +"";