数据库中的日期如何与系统日期进行比较？？？！！

Question

sendy,sendm,sendd分别为数据库中的年，月，日，为int型。点击LinkButton3，让datalist按条件进行选择。不知道是哪里错了，每次都显示"没有您要查询的内容！"
protected void LinkButton3_Click(object sender, EventArgs e)
  {
  int y=Convert.ToInt32(DateTime.Now.Year);
  int m = Convert.ToInt32(DateTime.Now.Month);
  int d =Convert.ToInt32(DateTime.Now.Day);
  string sqlText = "select * from tb_show where sendy <= " + y + " and sendm <= " + m + " and sendd < " + d+" order by sid desc";
  DataSet ds = sb.GetShowInfo(sqlText);
  if (ds.Tables[0].Rows.Count == 0)
  {
  Label4.Text = "没有您要查询的内容！";
  }
  else
  {
  Label4.Text = "";
  }
  DataList1.DataSource = ds;
  DataList1.DataBind();
  }

Answer 1

我建议你将sqlText的值打出来看看, 或者先将这个sql语句放到数据库里执行下看看有没结果.

另外,年月日肯定是一个组合项, 你不能用这样的sendy <= " + y + " and sendm <= " + m + " and sendd < " + d+" 来筛选 比如 我选择的是2012,10,2号,按你的sql语句,2011,10,10号就不能入选.

这里我有两个方案拟可以参考下:

第一, 将这三个整型数字加起来: sendr = y* 10000 + m* 100 + d, 然后sql语句是这个样子: "select * from tb_show where sendy * 10000 + sendm * 100 + sendd <  " + sendr  + " order by sid desc"

第二, select * from tb_show where sendy < y or (sendy = y and sendm < m) Or (sendy = y and sendm = m and sendd < d)

---

Mike Feng
MSDN Community Support | Feedback to us
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

非常感谢！！