C#使用两个dateTimePicker查询access数据库一段时间内的数据时查询语句出错。

huanyinhai 2013-01-09 06:56:56

首先，我Access数据库的连接是没有问题的，表名是payment，其中字段DateTime在payment表中数据类型是日期/时间，但查询语句老是有问题我试用了以下查询语句都不成功。求高手解答！
string createdb = "select * from payment where between '" + dateTimePicker3.Text + "' and '" + dateTimePicker4.Text + "'";

string createdb = "select * from payment where DateTime>= '" + dateTimePicker3.Text + "' and DateTime<='" + dateTimePicker4.Text + "'";

string createdb = "select * from payment where DateTime>= '" + dateTimePicker3.Value+ "' and DateTime<='" + dateTimePicker4.Value + "'";

string createdb = "select * from payment where between '" + dateTimePicker3.Value.ToString("yyyy/mm/dd")+ "' and '" + dateTimePicker4.Value.ToString("yyyy/mm/dd") + "'";

...全文

280 9 打赏收藏转发到动态举报

写回复

用AI写文章

9 条回复

切换为时间正序

请发表友善的回复…

发表回复

lihuan09218 2013-09-16

打赏
举报

你保存在数据库中的是两个 String 类型，无法比较大小

huanyinhai 2013-01-17

打赏
举报

引用

回复于： 2013-01-17 14:48:59 string createdb = "select * from payment where DateTime between #" + dateTimePicker3.Value.ToString("yyyy-MM-dd 00:00:00")+ "# and #" + dateTimePicker4.Value.ToString("yyyy-MM-dd 23:59:59") + "#";

感谢楼上最后正确的查询语句是： string createdb = "select * from payment where DateTime between #" + dateTimePicker3.Value.ToString("yyyy/MM/dd 00:00:00") + "# and #" + dateTimePicker4.Value.ToString("yyyy/MM/dd 23:59:59") + "#";

zfjclark 2013-01-17

打赏
举报

string createdb = "select * from payment where DateTime between #" + dateTimePicker3.Value.ToString("yyyy-MM-dd 00:00:00")+ "# and #" + dateTimePicker4.Value.ToString("yyyy-MM-dd 23:59:59") + "#";

huanyinhai 2013-01-17

打赏
举报

引用

string createdb = "select * from payment where between #" + dateTimePicker3.Value.ToString("yyyy-MM-dd 00:00:00")+ "# and #" + dateTimePicker4.Value.ToString("yyyy-MM-dd 23:59:59") + "#";

还是查询失败

zfjclark 2013-01-11

打赏
举报

string createdb = "select * from payment where between #" + dateTimePicker3.Value.ToString("yyyy-MM-dd 00:00:00")+ "# and #" + dateTimePicker4.Value.ToString("yyyy-MM-dd 23:59:59") + "#";