I am developing my own module and I am using GridViews to show a preview of the data. I would like to be able to use the filtering options that this component gives us but it seems that filtering on a GridView is only available 'if SelectMethod returns a DataSet or a DataTable' however, the underlying SelectMethod for my GridView returns an ArrayList:
Public Class OrderController
...
Public Shared Function ListAllOrders(ByVal filterExpression As String, ByVal sortExpression As String, ByVal maximumRows As Integer, ByVal startRowIndex As Integer) As ArrayList
Return CBO.FillCollection(DataProvider.Instance().ListAllOrders(filterExpression, sortExpression, maximumRows, startRowIndex), GetType(OrderInfo))
End Function
...
End Class
All possible overloads for CBO.FillCollection accept an IDataReader as first argument and always return either Collections.ArrayList, or Collections.IList or Generic.List(Of T) but none of them return the desired a DataSet or DataTable.
Has anyone faced this problem before? Is the class CBO under development for this issue? Any expected date for an update to avoid writing and writing code for filtering when GridView does the job out-of-the-box?
Thanks and regards.