We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: June 24, 2019).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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
loading
Tags: GridGroupingControl
Mel
Asked On February 6, 2020 12:33 PM UTC

Hello,

I describe a scenary. I need help about this:

So

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

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; 
} 
 
 
 
Please get back to us, if we misunderstood your scenario. 
 
Regards, 
Arulpriya 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

Live Chat Icon For mobile
Live Chat Icon