Hello,

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.

Hristo

Hi Gridhar,

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.

Hristo