Dataview RowFilter using date range

Question

Hi Guys

Always datetime operation needs special care while doing coding
While coding recently i have suffered to use Row filter using Date range

I have set of rows in datatable and i convert it to dataview and
have to filter rows between two date range

Can anyone show the sample code pls

Abhimanyu K Vatsa · Answer

Ok.... I have an already working sample but little different than your issue. Please check out may will help you. thanks

Vulpes · Answer

If 'Date' is the name of your column I'd try something like: dataView.RowFilter = Date >= #1//1/1984# AND Date

narasimman g · Answer

@Abimanyu Thanks for the response Already i have seen that link there they explained only to filter using single date I want to filter between range such as we use in sql Datetime Between '1984-01-01 00:00:00' And '1986-1-1 00:00:00'; @kirtan Thanks for the response I know the format to enclose the dates but how to filter rows between two date ranges

Kirtan Patel · Answer

just write your date inside #Date Here # instead of writing in ' ' (Single Quotes )

Abhimanyu K Vatsa · Answer

Yes you are right it needs special care. find the sample code here once upon a time this helped me lot http://www.csharp-examples.net/dataview-rowfilter/ hope this helps