Betwen Operator in DataView.RowFilter
Have you ever tried to use the Between operator when you needed to filter the DataView object to retrieve a range of records?
When you use
DataView.RowFilter = "ID BETWEEN 1 AND 5";
An error message is displayed "The expression contains unsupported operator 'Between'.". Eventhough if you use this query in SQL Server, it will return a result set.
Walkaround:
You can modify the RowFilter property to use a different filter expression which will return your needed result set
DataView.RowFilter = "ID >= 1 AND ID<=5";
Best Regards,
HC