Selection out of range on RadComboBox.OnDataBinding in UI for ASP.NET AJAX ComboBox

Phil

273 posts

Member since:
Jul 2008

Posted 14 Jul 2011 Link to this post

Hi:

I have just gone live on an application that ports data from a legacy system. I am getting an exception on editing existing data. Essentially, the case is different. So, SQL is happy with the foreign key data, but the RadComboBox is not and causes an exception. Any suggestions?

Phil

Dimitar Terziev

Admin

1268 posts

Posted 18 Jul 2011 Link to this post

Hi Phil,

In order to troubleshoot this issue, please try to provide more information on your particular implementation that you are using.

My suggestion is to open a support ticket which will speed up the troubleshooting process.

All the best,
Dimitar Terziev
the Telerik team

Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!

Phil

273 posts

Member since:
Jul 2008

Posted 18 Jul 2011 Link to this post

I think a support ticket is a little excessive. Do you have any suggestions?
Phil

Dimitar Terziev

Admin

1268 posts

Posted 20 Jul 2011 Link to this post

Hello Phil,

The information provided in your previous post is insufficient in find the cause of your issue. Please try to provide me with the implementation of your combobox and the data base query used.

Regards,
Dimitar Terziev
the Telerik team

Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!

Phil

273 posts

Member since:
Jul 2008

Posted 20 Jul 2011 Link to this post

Hi:

The value in the foreign key table (combobox) is say:
HELLO
and the value in the table being updated is say:
Hello
The combobox is doing case sensitive lookup, so it causes a 'Selection out of range' exception.

Phil

Dimitar Terziev

Admin

1268 posts

Posted 26 Jul 2011 Link to this post

Hello Phil,

What seems the solution to this issue is manually converting the value from the RadComboBox to lower case and then updating the table with the new value.

Best wishes,
Dimitar Terziev
the Telerik team

Register for the Q2 2011 What's New Webinar Week. Mark your calendar for the week starting July 18th and book your seat for a walk through of all the exciting stuff we will ship with the new release!

Phil

273 posts

Member since:
Jul 2008

Posted 28 Jul 2011 Link to this post

Hi:

try:

UPDATE primaryTable

SET keyField = foreignKeyTable.keyField

FROM foreignKeyTable

WHERE primaryTable.keyField = foreignKeyTable.keyField

Dimitar Terziev

Admin

1268 posts

Posted 02 Aug 2011 Link to this post

Hello Phil,

Please refer to the following forum threads here and here where you could find a solution how to make both of the table column values lower case.

I hope this would help.

Kind regards,
Dimitar Terziev
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.