现在界面上输入开始时间和截取时间,去和数据库里的时间比较数据库里也有两个字段startProcessDate,EndProcessDate现在比如输入的是2005-5-1,和2005-5-31,就把数据库里满足这个时间段的所有字段显示出来-------------界面以取到的信息
DateTime dt1 = RadDatePicker1.SelectedDate.Value;
DateTime dt2 = RadDatePicker2.SelectedDate.Value;数据库里也准备好了
where a.startProcessDate='" + dt1.ToString("yyyy-MM-dd") + "'
and a.EndProcessDate='" + dt2.ToString("yyyy-MM-dd") + "'感觉就差一点,急啊
DateTime dt1 = RadDatePicker1.SelectedDate.Value;
DateTime dt2 = RadDatePicker2.SelectedDate.Value;数据库里也准备好了
where a.startProcessDate='" + dt1.ToString("yyyy-MM-dd") + "'
and a.EndProcessDate='" + dt2.ToString("yyyy-MM-dd") + "'感觉就差一点,急啊
and a.EndProcessDate<='" + dt2.ToString("yyyy-MM-dd") + "'
最好给表里的内容和给果看看
-------
DateTime dt1 = RadDatePicker1.SelectedDate.Value;
DateTime dt2 = RadDatePicker2.SelectedDate.Value;select b.name as name,count(a.id) as score from T_question a left join T_questiontype b on a.QTID=b.id where a.startProcessDate>='" + dt1.ToString("yyyy-MM-dd") + "' and a.EndProcessDate<='" + dt2.ToString("yyyy-MM-dd") + "'group by b.name order by count(a.id) asc还需要改吗,我好不容易做的查询,因为这个时间区间,怕搞混淆了