关于dataview 时间段筛选问题

[子益]

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()+"#";

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

[linjone]

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"

[linjone]

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