This is a migrated thread and some comments may be shown as answers.

radcombobox not getting the same results from DB

6 Answers 79 Views
ComboBox
This is a migrated thread and some comments may be shown as answers.
Lighthouse Developer
Top achievements
Rank 1
Lighthouse Developer asked on 11 Nov 2010, 10:53 AM
Hi,

I have the collation of my database as CI_AI. While the query I use returns the expected records from db,
when they are returned in the radcombobox, the records listed are fewer. Whatever I do, the returned results are
somehow being filtered with accent sensitive properties.

Anyone seen this before?

Thank you

6 Answers, 1 is accepted

Sort by
0
Simon
Telerik team
answered on 16 Nov 2010, 02:36 PM
Hi Lighthouse Developer,

RadComboBox does not filter the data source automatically unless it is using Automatic Load On Demand.

Is this your case? Can you give a concrete example of the manifestation of the issue? What kind of data records are filtered out?

Greetings,
Simon
the Telerik team
Browse the vast support resources we have to jumpstart your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.
0
Francisco
Top achievements
Rank 1
answered on 24 Jan 2011, 06:03 PM
Hi,

Since I've got the same problem I didn't want to open a new thread. Is this resolved?

I want to filter a radcombobox in an accent insensitive way, is it possible?

I can't change the collation of my database table because there are some dependencies with other applications.

Kind Regards,
0
Simon
Telerik team
answered on 25 Jan 2011, 05:13 PM
Hi Francisco,

Can you please let me know whether you are using Automatic Load On Demand or some other means of filtering the underlying data?

Kind regards,
Simon
the Telerik team
Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.
0
Francisco
Top achievements
Rank 1
answered on 25 Jan 2011, 05:23 PM
Hi Simon,

Thanks for your response.

I'm using automatic load on demand, and in the ItemsRequested event I load the RadCombo with a SqlCommand which retrieves the data with accents, but If I set the property "Filter" to any value, it filters the results accent sensitive even if the SqlCommand retrieved acccent insentive results.

Regards,
0
Simon
Telerik team
answered on 27 Jan 2011, 06:26 PM
Hi Lighthouse Developer,

We are aware that Automatic Load On Demand cannot properly handle accents and will address this in future versions of RadComboBox. However in your case, since you are already filtering the data in the SQL server, you do not need the Filter functionality as both operations actually do the same thing. So I suggest you stop RCB's filtering if you do not need it for the client-side highlighting.

Please let me know if you have additional questions.

All the best,
Simon
the Telerik team
Browse the vast support resources we have to jump start your development with RadControls for ASP.NET AJAX. See how to integrate our AJAX controls seamlessly in SharePoint 2007/2010 visiting our common SharePoint portal.
0
Francisco
Top achievements
Rank 1
answered on 27 Jan 2011, 06:34 PM
Thanks for your response Simon, actually what I did was that, disabled the filtering but I wanted to highlight the user input.

Anyway, thank you so much.

Kind Regards,
Tags
ComboBox
Asked by
Lighthouse Developer
Top achievements
Rank 1
Answers by
Simon
Telerik team
Francisco
Top achievements
Rank 1
Share this question
or