Anyone knows how to do this?

[Chris Wagner]

Hi,

Anyone knows how to put this in the datarow filter in ADO.NET:

"SELECT * FROM Product WHERE datediff('d',ProductPDFDate,now()) < 90"

 

[William Ryan eMVP]

You can use the date function in VB.NET or C# to get the value of the
DateTime.Now - 90. Then you can just use RowFilter = "ProductPDFDate > #"
+ YourDateVariable + "'"

--
W.G. Ryan MVP Windows - Embedded

http://forums.devbuzz.com
http://www.knowdotnet.com/dataaccess.html
http://www.msmvps.com/williamryan/

 

[Chris Wagner]

Actually, the 90 is not a constant, it's a column in the table. Is there a
way or this is a limitation of ADO.NET?

"SELECT * FROM Product WHERE datediff('d',ProductPDFDate,now()) < MaxSecond"

Thanks

 

[William Ryan eMVP]

I know in the expression syntax that there's no datediff nor now(). You may
be able to subtract the columsn but I don't have my IDE in front of me. Let
me give it a try shortly and I'll get back to you.

Cheers,

Bill

--
W.G. Ryan MVP Windows - Embedded

http://forums.devbuzz.com
http://www.knowdotnet.com/dataaccess.html
http://www.msmvps.com/williamryan/