关于两个DateTime列的差异的Datarow.Filter [英] Datarow.Filter on difference of two DateTime Columns

问题描述

大家好，

我有一个数据表，其中包含3行项目，开始日期和结束日期。我有两个文本框''Min Days''和''Max Days''。现在我必须过滤数据表，以便得到项目，其持续时间（截止日期 - 开始日期）大于最小日期且小于最大天数''。我想使用DataView.Rowfilter属性。请尽快回复。



谢谢和问候，

Srivikas。

Hi everybody,
I have a datatable which contains 3 rows ''Project'', ''Start Date'' and ''End Date''. And I have two text boxes ''Min Days'' and ''Max Days''. Now I have to filter the datatable so that I get the ''Project''s which have a duration(''Due Date'' - ''Start Date'') greater than ''Min Days'' and less than ''Max Days''. I want to use the DataView.Rowfilter property. Please reply as soon as possible.

Thanks & Regards,
Srivikas.

推荐答案

使用datediff http://www.w3schools.com/sql/func_datediff.asp [ ^ ]



逻辑是你的......

use datediff http://www.w3schools.com/sql/func_datediff.asp[^]

logic is yours...

让我们说

dv是你的数据视图然后你指定

dv.RowFilter = （日期差异）>最小日期和（日期差异）<最大天数



希望这有用。

Let us say
dv is your dataview then you specify
dv.RowFilter = "(Date Difference) > Min Days and (Date Difference) < Max Days"

Hope this is helpful.

您必须在程序级别计算日期差异，请点击此链接



http://victoriayudin.com/2008/10/27/sql-server-how-to-get-date-差异/ [ ^ ] [ ]

You must calculate date diff at procedure level follow this link

http://victoriayudin.com/2008/10/27/sql-server-how-to-get-date-differences/[^][]

dv.RowFilter = "difference  > " minDays + " and " + "difference  < " + maxDays;

问题是你不使用Linq的原因？

谢谢

Question is why you are not using Linq?
Thanks

这篇关于关于两个DateTime列的差异的Datarow.Filter的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！