We need to get all the filtered records in the webdata grid into a dataset for processing the same.
If there are totally around 5000 records and 2000 records that matches particular filters then we need to get those 2000 records into the dataset/datatable irrespective of paging.
Thanks in Advance
I am currently working to create a sample for you demonstrating how to achieve the required. I will update you by the end of the day. Please let me know if you have other questions in the meantime.
Please accept my apologies for the late response. You can use the DataFiltered server side event to retrieve the filtered records (irrespective of paging) into a new DataTable:
protected void WebDataGrid1_DataFiltered(object sender, FilteredEventArgs e)
var rowFilter = (((DataTable)((WebDataGrid)sender).DataSource).DefaultView).RowFilter;
DataTable table = ((DataTable)((WebDataGrid)sender).DataSource);
DataView dv = new DataView(table);
dv.RowFilter = rowFilter;
DataTable filteredTable = dv.ToTable();
Please find the sample attached and let me know if you have further questions, I will be glad to help.