Load data on demand by textbox filter

Thread ID:	Created:	Updated:	Platform:	Replies:
151311	Feb 6,2020 12:33 PM UTC	Feb 7,2020 09:31 AM UTC	WinForms	1

Subscribe to this post

Tags: GridGroupingControl

Mel

Asked On February 6, 2020 12:33 PM UTC

Hello,

I describe a scenary. I need help about this:

We have on database more than 80k rows. We want load only the last 5k at the first time. Now at right moment its OK.

The problem it is:

If we want filter on database using the header filters we can´t because the filters only seach on datasource of gridgroupingcontrol.

Exist any event or something that when we type caracteres on textbox-filter can get the text-box filter content and use it to send a query to database and change the datasource of the control???

Thanks

Reply | Reply with quote

Arulpriya Ramalingam [Syncfusion]

Replied On February 7, 2020 09:31 AM UTC

Hi Mel,

Thank you for your interest in Syncfusion products.

We suspect that you have applied a RowFilter for DataTable of your datasource and bind the resulted table into GridGroupingControl and to filter the records dynamically at run time you have wired the GridDynamicFilter for the grid. If yes, the RecordFilters.Changed event will be invoked when the records are filtered from the grid and the compare value can be retrieved from the FilterConditions collection. Please refer to the below code and sample.

Example code

//Event subscription

this.gridGroupingControl1.TableDescriptor.RecordFilters.Changed += RecordFilters_Changed;

//Event customization

private void RecordFilters_Changed(object sender, Syncfusion.Collections.ListPropertyChangedEventArgs e)

{

RecordFilterDescriptorCollection recordFilters = this.gridGroupingControl1.TableDescriptor.RecordFilters;

string compareText = recordFilters[recordFilters.Count - 1].Conditions[0].CompareText;

}

Sample link: https://www.syncfusion.com/downloads/support/directtrac/general/ze/RecordFilters1062112218

For reference: https://www.syncfusion.com/forums/134841/how-to-get-filter-string-when-filter-changed-for-excel-filter

Please get back to us, if we misunderstood your scenario.

Regards,

Arulpriya

Reply | Reply with quote

CONTACT US

Load data on demand by textbox filter

Thread ID:

Created:

Updated:

Platform:

Replies:

Please sign in to access our forum

CONTACT US