按两个日期搜索数据，并按VB.NET中的帐号过滤 [英] Search data by two dates and filter by account number in VB.NET

问题描述

Dim命令As New SqlCommand（选择p.VJTEXT，p.PAYFILENBR，p.TRANSNBR，p.ITEMTYPE，p.LISTTOTAL，pf.POSTDATE，p.CTLDATA

来自PAYTRANS p， payfiles pf

其中p.PAYFILENBR = pf.PAYFILENBR

和p.wsnbr = pf.WSNBR

和p.branchnbr = pf.BRANCHNBR

和p.usernbr = pf.usernbr

和p.acctnbr不是NULL

和@ d1和@ d2之间的pf.POSTDATE

由pf.POSTDATE命令asc，连接）



command.Parameters.Add（@ d1，SqlDbType.Date）.Value = DateTimePicker1.Value

逗号nd.Parameters.Add（@ d2，SqlDbType.Date）.Value = DateTimePicker2.Value



我尝试过：



现在数据来自gridview中的两个日期，但我想通过ITEMTYPE过滤数据

解决方案

< blockquote>所以将它添加到你的WHERE子句：

 ... 
 和 pf。 POSTDATE    @ d1   AND   @ d2  
  AND  p.ItemType =  @ IT  
  order   by  pf.POSTDATE  asc  

并添加所需的项目类型作为第三个参数。

Dim command As New SqlCommand("select p.VJTEXT, p.PAYFILENBR , p.TRANSNBR,p.ITEMTYPE, p.LISTTOTAL ,pf.POSTDATE,p.CTLDATA
from PAYTRANS p, payfiles pf
where p.PAYFILENBR = pf.PAYFILENBR
and p.wsnbr = pf.WSNBR
and p.branchnbr = pf.BRANCHNBR
and p.usernbr = pf.usernbr
and p.acctnbr is not NULL
and pf.POSTDATE between @d1 AND @d2
order by pf.POSTDATE asc", connection)

command.Parameters.Add("@d1", SqlDbType.Date).Value = DateTimePicker1.Value
command.Parameters.Add("@d2", SqlDbType.Date).Value = DateTimePicker2.Value

What I have tried:

right now the data coming out by two dates in a gridview but I want to filter data by ITEMTYPE

解决方案

So add it to your WHERE clause:

...
and pf.POSTDATE between @d1 AND @d2 
AND p.ItemType = @IT
order by pf.POSTDATE asc

And add the required item type as a third parameter.

这篇关于按两个日期搜索数据，并按VB.NET中的帐号过滤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！