通过仅搜索日期从访问数据库表中选择记录 [英] select record from access db table by search only date
问题描述
各位大家请大家帮助我。现在我遇到一个问题是
(查询表达式中的语法错误(缺少运算符))何时选择记录形式按日期搜索表格
我的表格格式字段名称(Upload_Date)数据类型(日期/时间)(数据库类型ms access2007)
my查询是
从V_Inventory_Update_Info中选择*,其中upload_Date =+ dateTimePicker1.Value.Date +,续;
da.Fill(dt = new DataTable());
请轻松解决这个问题
Hello everybody please help me.Right now i suffer a problem which is
(Syntax error (missing operator) in query expression) when is select record form a table search by date
my table format field name(Upload_Date) data Type (Date/Time) (database type ms access2007)
my query is
select * from V_Inventory_Update_Info where upload_Date="+dateTimePicker1.Value.Date+"",Cont;
da.Fill(dt=new DataTable ());
please solve this problem very easily
推荐答案
不要做就这样。
相反,使用参数化查询,你的问题也会消失。
Don't do it that way.
Instead, use a parameterized query and your problem will vanish as well.
这篇关于通过仅搜索日期从访问数据库表中选择记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!