being able to search on multiple columns works great on the datagrid, is it possible to retrieve
the records in the grid after searching ? ie if I have 100 products and after using the search my grid shows 10 records is it possible for me to retrieve those 10 records ?
Thanks for your help
If you are using SQL or service as data source the returned records are bound to the grid data property. If paging is enabled and filtered records are more than page size only page size data are returned.
You can check DataGrid loadData event where the grid will request the data source and will assign the result to a Page property bound to DataGrid Data property.