选择日期时间范围的项目集合的语法是什么 [英] what is syntax to select collection of item with rang of datetime

问题描述

 OleDbParameter DataTime_Join1 = new OleDbParameter（@ DataTime_Join1，OleDbType.Date）; 
 DataTime_Join1.Value = time1; 
 Command.Parameters.Add（DataTime_Join1）; 
 
 OleDbParameter DataTime_Join2 = new OleDbParameter（@ DataTime_Join2，OleDbType.Date）; 
 DataTime_Join2.Value = time2; 
 Command.Parameters.Add（DataTime_Join2）; 
 
 Command.CommandText =select * from table where DataTime_Join1> @DataTime_Join1 and DataTime_Join2< @DataTime_Join2; 

解决方案

您的查询应如下所示：

 PARAMETERS dt1  DATE ，dt2  DATE ; 
 选择 * 来自 表 其中 DataTime_Join1>＃dt1＃和 DataTime_Join2< #dt2＃

然后向命令添加参数：

 OleDbCommand command =  new  OleDbCommand（commandText，connection ）; 
 command.CommandText =   ^^^以上查询^^^ 
 command.Parameters.Add（  dt1，OleDbType.Date）; 
 command.Parameters [  dt1]。Value = time1; 
 command.Parameters.Add（  dt2，OleDbType.Date）; 
 command.Parameters [  dt2]。Value = time2; 

OleDbParameter DataTime_Join1 = new OleDbParameter(@DataTime_Join1, OleDbType.Date);
DataTime_Join1.Value = time1;
Command.Parameters.Add(DataTime_Join1);

OleDbParameter DataTime_Join2 = new OleDbParameter(@DataTime_Join2, OleDbType.Date);
DataTime_Join2.Value = time2;
Command.Parameters.Add(DataTime_Join2);

Command.CommandText ="select * from  table where DataTime_Join1>@DataTime_Join1 and DataTime_Join2<@DataTime_Join2";

解决方案

Your query should looks like:

PARAMETERS dt1 DATE, dt2 DATE;
select * from  table where DataTime_Join1>#dt1# and DataTime_Join2<#dt2#

Then add parameters to command:

OleDbCommand command = new OleDbCommand(commandText, connection);
command.CommandText = "^^^above query^^^"
command.Parameters.Add("dt1", OleDbType.Date);
command.Parameters["dt1"].Value = time1;
command.Parameters.Add("dt2", OleDbType.Date);
command.Parameters["dt2"].Value = time2;

这篇关于选择日期时间范围的项目集合的语法是什么的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！