日期查询表达式 [英] Date query expression

问题描述

大家好，

日期数据类型字段的正确查询表达式是什么，以便使用OleDBCommand在MS Access SQL中进行选择和更新，真的，我已经厌倦了尝试

Whats the correct query expression for date datatype field in order to select and update in MS Access SQL using OleDBCommand, realy i am get tired of trying

谢谢

推荐答案

如果将日期直接放入SQL语句中，则变量(或值)必须放在散列字符之间(例如#4/13/2017#).为避免此类语法问题，最好使用OleDbCommand的Parameters集合 类:

If you are putting the date directly into the SQL statement then the variable (or value) must be enclosed between hash characters (e.g. #4/13/2017#). To avoid this type of syntactical issue it is preferable to use the Parameters collection of the OleDbCommand Class:

System.Data.OleDb.OleDbConnection AccessConn = new System.Data.OleDb.OleDbConnection(("Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=C:\\Test Files\\db1 XP.mdb;"));
AccessConn.Open();
System.Data.OleDb.OleDbCommand AccessCommand = new System.Data.OleDb.OleDbCommand("INSERT INTO [TableName] (ID, CreateDate) VALUES (@ID, @DateVal)", AccessConn);
System.DateTime DateValue = 9/30/2011 12:00:00 AM;
AccessCommand.Parameters.AddWithValue("@ID", 12345);
AccessCommand.Parameters.AddWithValue("@DateVal", DateValue);
AccessCommand.ExecuteNonQuery();
AccessConn.Close();

这篇关于日期查询表达式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！