Selection out of range on RadComboBox.OnDataBinding

8 posts, 0 answers
  1. Phil
    Phil avatar
    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
  2. Dimitar Terziev
    Admin
    Dimitar Terziev avatar
    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!

  3. Phil
    Phil avatar
    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
  4. Dimitar Terziev
    Admin
    Dimitar Terziev avatar
    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!

  5. Phil
    Phil avatar
    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
  6. Dimitar Terziev
    Admin
    Dimitar Terziev avatar
    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!

  7. Phil
    Phil avatar
    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
  8. Dimitar Terziev
    Admin
    Dimitar Terziev avatar
    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.

Back to Top