假设你这个记录时间的字段为InputTimestring sql="Select * from YourTable Where CDate(InputTime)>=#"+dateTimePicker1.Text+"# And CDate(InputTime)<=#"+dateTimePicker2.Text+"#";
汗了,这种格式是转换不了的,干脆就用字符串比较算了。。 string sql="Select * from YourTable Where InputTime>='"+dateTimePicker1.Value.ToString("yyyyMMdd HHmmss")+"' And InputTime)<='"+dateTimePicker2.Value.ToString("yyyyMMdd HHmmss")+"'";
可以在C#中使用String.Format()重載實現 String sql=String.Format("SELECT * FROM YourTable WHERE InputTime BETWEEN {0} AND {1}", dateTimePicker1.Value, dateTimePicker2.Value) ; 不妨一試.
string sql="Select * from YourTable Where InputTime>='"+dateTimePicker1.Value.ToString("yyyyMMdd HHmmss")+"' And InputTime)<='"+dateTimePicker2.Value.ToString("yyyyMMdd HHmmss")+"'";
String sql=String.Format("SELECT * FROM YourTable WHERE InputTime BETWEEN {0} AND {1}", dateTimePicker1.Value, dateTimePicker2.Value) ;
不妨一試.