关于dataview 时间段筛选问题

子益 2007-09-09 04:06:50

wheresql +=" and " + _mytime +">=#"+ DateTime.Parse(txt_time1.Text).Month.ToString() +"/"+ DateTime.Parse(txt_time1.Text).Day.ToString()+"/"+DateTime.Parse(txt_time1.Text).Year.ToString()+"# and "+ _mytime +"<=#"+ DateTime.Parse(txt_time2.Text).Month.ToString() +"/"+ DateTime.Parse(txt_time2.Text).Day.ToString()+"/"+DateTime.Parse(txt_time2.Text).Year.ToString()+"#";

我想实现一个日期字段中在一个时间段内的所有记录

...全文

1938 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

linjone 2007-09-09

打赏
举报

还可以改为:
wheresql+= " and "+ _mytime +">='" + txt_time1.Text+"' and "+ _mytime +"<='" + txt_time2.Text + "'";

linjone 2007-09-09

打赏
举报

wheresql +=" and " + _mytime +">=#"+ DateTime.Parse(txt_time1.Text).Month.ToString() +"/"+ DateTime.Parse(txt_time1.Text).Day.ToString()+"/"+DateTime.Parse(txt_time1.Text).Year.ToString()+"# and "+ _mytime +"<=#"+ DateTime.Parse(txt_time2.Text).Month.ToString() +"/"+ DateTime.Parse(txt_time2.Text).Day.ToString()+"/"+DateTime.Parse(txt_time2.Text).Year.ToString()+"#";

改一下!!!!

SQL Server数据库可以改为:
wheresql +=" and charindex('" + txt_time1.Text.Replace("'", " ") + "',"+ _mytime +")>0 and charindex('" + txt_time2.Text.Replace("'", " ") + "',"+ _mytime +")>0"