Hi,
I have a Ultrawebgrid with LoadOnDemand and Filter row set. I need to be able to pass the FILTERED results from the grid to another page. Is there a way to acces the filtered dataView the Grid is bound to and save it into a session and read it on another page?
Thanks,
Jakub
There is no way to get the filtered data out of the grid in one shot from my understanding. Depending on the size of your grid, you may be able to just build the dataset from the grid after you have filtered it down to what you would like it to look like. If you working with a somewhat small record set then you wouldn't notice much a performance problem. On the other hand, if you are working with large record sets then Im afriad the fastest way to accomplish this would be to write a routine that converted the applied filter conditions the grid uses into useable strings to filter the dataview that is being used by the grid.
A quick example of the latter suggestion would look like this:
Dim str As String = ""
Case Infragistics.WebUI.UltraWebGrid.FilterComparisionOperator.Equals
End Select
SessionDataView.RowFilter = str
End Sub
Thats just something I through together so you'll definalty wanna look over it.
That is a great start. Thanks.
Only problem, this event does not fire on Client Filtering which is what I use. Is there a way to gather the same info on client filter event and pop it into a session or return it somehow so it can be used on another page?
Thanks again for your help
The Server side filtering is excruciatingly slow even with small datasets (<100 rows).
Would the AfterRowFilterApplied Property give me access to the filter strings ClientSide?
Thanks for your hlep. I am trying to decide if our team will use Infragistics or Telerik grid for the next large project.
Have you tried using the LoadOnDemand technology with infragistics? I have client side filtering enabled with LoadOnDemand enabled and that event will fire for me on the server. I would definatly suggest using the Infragistics Grid if only for the xmlHttpRequest object it provides.
If you would like to know how to use LoadOnDemand let me know and I will supply you with the source code to do so. There are also ways of increasing performance of the filtering performance.