blocks|key|4223055|text|不需要getSqlDate函数。您可以使用String.Format()格式化日期：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4223056|String.Format("{0:yyyy-MM-dd}+00:00:00",+myDateTime)|code-block|syntax|javascript|4223057|或|4223058|myDateTime.Date.ToString("yyyy-MM-dd")+%2B+"+00:00:00"|4223059|您可以像这样过滤绑定源：|4223060|myBindingSource.Filter+=+String.Format("myDateField+>=+'{0:yyyy-MM-dd}'+AND+myDateField+<+'{1:yyyy-MM-dd}'",+myDateTime,+myDateTime.AddDays(1));|4223061|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|S|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|T|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

The getSqlDate function is not needed. You can use String.Format() to format dates:

<pre><code>String.Format("{0:yyyy-MM-dd} 00:00:00", myDateTime)
</code></pre>

OR

<pre><code>myDateTime.Date.ToString("yyyy-MM-dd") + " 00:00:00"
</code></pre>

You could filter the binding source like this:

<pre><code>myBindingSource.Filter = String.Format("myDateField &gt;= '{0:yyyy-MM-dd}' AND myDateField &lt; '{1:yyyy-MM-dd}'", myDateTime, myDateTime.AddDays(1));
</code></pre>

blocks|key|159846|text|谢谢你汤姆·H。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|159847|是的，我想去掉过滤器中datetime的时间部分，你的建议非常有效。|159848|我将把完整的解决方案留给其他人：|159849|myBindingSource.Filter+=+"myDateField+>=+'"+%2B+getSqlDate(myDateTime)+%2B+"'+AND+myDateField+<+'"+%2B+getSqlDate(myDateTime.AddDays(1))+%2B+"'";|code-block|syntax|javascript|159850|其中getSqlDate函数为：|159851|string+getSqlDate(DateTime+date)+{
++++string+year+=+""+%2B+date.Year;
++++string+month+=+(date.Month+<+10)+?+"0"+%2B+date.Month+:+""+%2B+date.Month;
++++string+day+=+(date.Day+<+10)+?+"0"+%2B+date.Day+:+""+%2B+date.Day;

++++return+year+%2B+"-"+%2B+month+%2B+"-"+%2B+day+%2B+"+00:00:00";
}|159852|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|S|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|T|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|H|7|V|8|@]|9|@]|A|$I|J]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

Thank you Tom H.

Yes, i wanted to eliminate the time portion of the datetime in the filter and your suggestion works perfectly.

I`ll leave the complete solution for others:

<pre><code>myBindingSource.Filter = "myDateField &gt;= '" + getSqlDate(myDateTime) + "' AND myDateField &lt; '" + getSqlDate(myDateTime.AddDays(1)) + "'";
</code></pre>

where getSqlDate function is:

<pre><code>string getSqlDate(DateTime date) {
 string year = "" + date.Year;
 string month = (date.Month &lt; 10) ? "0" + date.Month : "" + date.Month;
 string day = (date.Day &lt; 10) ? "0" + date.Day : "" + date.Day;

 return year + "-" + month + "-" + day + " 00:00:00";
}
</code></pre>

blocks|key|941962|text|对答案的更正:根据msdn，要获得mm的正确日期|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|941963|yyyy-mm-dd|code-block|syntax|javascript|941964|必须像这样大写；|941965|yyyy-MM-dd|941966|以获得格式正确的日期。|941967|entityMap|0|LINK|mutability|MUTABLE|url|http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx^0|H|2|9|4|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@$9|Z|A|10|B|C]]|D|@$9|11|A|12|1|13]]|E|$]]|$1|F|3|G|5|H|7|14|8|@]|D|@]|E|$I|J]]|$1|K|3|L|5|6|7|15|8|@]|D|@]|E|$]]|$1|M|3|N|5|H|7|16|8|@]|D|@]|E|$I|J]]|$1|O|3|P|5|6|7|17|8|@]|D|@]|E|$]]|$1|Q|3|-4|5|6|7|18|8|@]|D|@]|E|$]]]|R|$S|$5|T|U|V|E|$W|X]]]]

A correction to the answer:
Accoring to <a href="http://msdn.microsoft.com/en-us/library/8kb3ddd4.aspx" rel="nofollow noreferrer">msdn</a>
,to get the correct date
the mm in 

<pre><code>yyyy-mm-dd
</code></pre>

would have to be capitalized
like so;

<pre><code>yyyy-MM-dd
</code></pre>

to get a correctly formatted date.

blocks|key|4222957|text|myDateField是数据集中字段的名称吗？我想你想要这样的表达：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4222958|myBindingSource.Filter+=+"myDateField+=+"+&+myDateTime.Date.ToString()|code-block|syntax|javascript|4222959|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Is myDateField the name of the field in the dataset? I think you want an expression like this:

<pre><code>myBindingSource.Filter = "myDateField = " &amp; myDateTime.Date.ToString()
</code></pre>

blocks|key|941924|text|您是否在询问如何消除筛选器中日期时间的时间部分？我不太熟悉MySQL，但是如果您使用任何类型的函数来返回datetime的日期部分，那么您很可能会扼杀在该列上使用索引进行查询的机会(现有的或将来的索引)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|941925|最好的办法是在前端创建一个筛选器，用于检查仅针对给定筛选器日期的范围。例如：|941926|myBindingSource.Filter+=+"myDateField+>=+"+&+<code+to+create+a+string+representing+12AM+of+your+date>+&
"+myDateField+<+"+&+<code+to+create+a+string+for+12AM+of+the+next+day>|code-block|syntax|javascript|941927|很抱歉没有确切的代码，但我是一个SQL开发人员，我缺乏VB/C#技能，这将需要我花更多的时间来想出函数，这可能会花费你更多的时间。:)|941928|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Are you asking how to eliminate the time portion of the datetime in the filter? I'm not too familiar with MySQL, but if you use any kind of function that returns the date portion of a datetime then you are likely to kill any chance of using an index on that column for the query (existing or future index).

Your best bet is to create a filter on the front end that checks for a range that is only for your given filter date. For example:

<pre><code>myBindingSource.Filter = "myDateField &gt;= " &amp; &lt;code to create a string representing 12AM of your date&gt; &amp;
" myDateField &lt; " &amp; &lt;code to create a string for 12AM of the next day&gt;
</code></pre>

Sorry for not having exact code, but I'm a SQL developer and my lack of VB/C# skills would require me to take a lot more time to come up with the functions then it would probably take you. :)

blocks|key|159960|text|对于DataGridView中的两个日期之间的搜索，您可以使用以下代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|159961|BindingSource1.Filter+=+"F5+>=+'"+%2B+maskedTextBox1.Text+%2B+"'+And+"+%2B+"F5+<=+'"+%2B+maskedTextBox2.Text+%2B+"'";

BindingSource1+:+my+datagridview+datasourc+load+in+BindingSource1+.
F5+++++++++++++:+name+of+your+header+column+in+datagridview+.+
maskedTextBox1+:+for+get+first+date+.
maskedTextBox2+:+for+get+second+date+.|code-block|syntax|javascript|159962|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

For search between two date in DataGridView you can use this code :

<pre><code>BindingSource1.Filter = "F5 &gt;= '" + maskedTextBox1.Text + "' And " + "F5 &lt;= '" + maskedTextBox2.Text + "'";

BindingSource1 : my datagridview datasourc load in BindingSource1 .
F5 : name of your header column in datagridview . 
maskedTextBox1 : for get first date .
maskedTextBox2 : for get second date .
</code></pre>

blocks|key|4223151|text|对于DataGridView中的两个日期之间的搜索，您可以使用以下代码：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4223152|BindingSource1.Filter+=+"F5+>=+'"+%2B+maskedTextBox1.Text+%2B+"'+And+"+%2B+"F5+<=+'"+%2B+maskedTextBox2.Text+%2B+"'";|code-block|syntax|javascript|4223153|BindingSource1+:在BindingSource1中加载我的datagridview数据源。F5+:+datagridview中标题列的名称。maskedTextBox1+:+get+first+datemaskedTextBox2+:用于获取第二次约会。|4223154|成为成功的"Arn_7“|4223155|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

For search between two date in DataGridView you can use this code :

<pre><code>BindingSource1.Filter = "F5 &gt;= '" + maskedTextBox1.Text + "' And " + "F5 &lt;= '" + maskedTextBox2.Text + "'";
</code></pre>

BindingSource1 : my datagridview datasourc load in BindingSource1 .
F5 : name of your header column in datagridview . 
maskedTextBox1 : for get first date .
maskedTextBox2 : for get second date .

Be successfull "Arn_7"

blocks|key|3376715|text|你需要添加像这样的信号引号"'2021-09-26'“。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3376716|myBindingSource.Filter+=+"myDateField+=+"+%2B+"'"+%2B+myDateTime.Date.ToString("yyyy-MM-dd")+%2B+"'"|code-block|syntax|javascript|3376717|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You will need to add signle quotes like this &quot;'2021-09-26'&quot;.
<pre><code>myBindingSource.Filter = &quot;myDateField = &quot; + &quot;'&quot; + myDateTime.Date.ToString(&quot;yyyy-MM-dd&quot;) + &quot;'&quot;
</code></pre>

I want to filter values from database based on date.

Date in a database contains values like this: 2008-12-28 18:00:00. And my class has a DateTime variable depending on which I want to filter. Ideally it would work like this:
<code>myBindingSource.Filter = "DATE(myDateField) = myDateTime.Date"</code> + adjusting myDateTime.Date format as needed.

But it throws an EvaluateException: "The expression contains undefined function call DATE()."

Although if I execute the SQL statement directly, I can use the DATE() function in filter. 

P.S. I use MYSQL DB with the Connector/Net 5.2

How can I solve this problem?

Thank You all for suggestions.

BindingSource Filter by date

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

教程

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云智能顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

EdgeOne AI 安全实战专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

聚焦“写作效率、视觉美观与运行性能”三方面进行全面升级，为您提供更高效、稳定的创作环境

社区富文本&Markdown编辑器全新改版上线，欢迎大家体验!

诚挚邀请您参与本次调研，分享您的真实使用感受与建议。您的反馈至关重要，感谢您的支持与参与！

社区新版编辑器体验调研

我想根据日期过滤数据库中的值。数据库中的Date包含如下值: 2008-12-28 18:00:00。我的类有一个DateTime变量，这取决于我想要过滤哪个变量。理想情况下，它是这样工作的：myBindingSource.Filter = "DATE(myDateField) = myDateTime.Date" +根据需要调整myDateTime.Date格式。但是它抛出了一个日期：“表达式包

问BindingSource按日期过滤
EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问BindingSource按日期过滤EN

回答 8

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问BindingSource按日期过滤
EN