how i can connect the autocomplete with mysql database?

6 posts, 0 answers
  1. mampus
    mampus avatar
    24 posts
    Member since:
    Oct 2010

    Posted 26 Dec 2010 Link to this post

    hi there....

    I have one textbox, then i want the autocomplete connect that to mysql database...
    so when the user type something, the column in my table on sql database will appear....
  2. Peter
    Admin
    Peter avatar
    1148 posts

    Posted 29 Dec 2010 Link to this post

    Hi mampus,

    Our textbox control does not support auto-complete out of the box. You should use RadDropDownList in case that you want to this feature. The RadDropDownList supports two modes of auto-complete AutoCompleteSuggest and AutoCompleteAppend. I suppose that in your case you should use the AutoCompleteAppend mode.

    Hope this helps. 


    Best wishes,
    Peter
    the Telerik team
    Q3’10 SP1 of RadControls for WinForms is available for download; also available is the Q1'11 Roadmap for Telerik Windows Forms controls.
  3. UI for WinForms is Visual Studio 2017 Ready
  4. Charles
    Charles avatar
    5 posts
    Member since:
    Dec 2013

    Posted 14 Jun Link to this post

    2016 Update for those who may find this while searching for a way to continuously update a append/suggest list from a large database.  Or, "How to dynamically fetch data from the database while typing?"

    Server side auto complete for RadDropDownList

    http://www.telerik.com/support/kb/winforms/details/server-side-auto-complete-for-raddr

    By Georgi Georgiev

    the example uses the Entity relationships classes for the database access.  It's a pretty nice piece of code. :D

     

  5. Hristo
    Admin
    Hristo avatar
    716 posts

    Posted 15 Jun Link to this post

    Hi Charles,

    Thank you for writing in the thread.

    Indeed, the approach suggested by my colleague resolves a scenario for dynamically fetching data as you type. In fact, as stated in the article the solution should work with any IEnumerable collection. 

    The link you posted appears to be incomplete, here is the correct one: http://www.telerik.com/support/kb/winforms/dropdown-checkeddropdown-and-list/details/server-side-auto-complete-for-raddropdownlist.

    I hope this helps.

    Regards,
    Hristo Merdjanov
    Telerik
    Check out the Windows Forms project converter, which aids the conversion process from standard Windows Forms applications written in C# or VB to Telerik UI for WinForms.For more information check out this blog post and share your thoughts.
  6. Charles
    Charles avatar
    5 posts
    Member since:
    Dec 2013

    Posted 15 Jun Link to this post

    Thanks for providing a corrected link. 

     

    That article resolved something I had wanted to do for quite some time.  Users are beginning to expect that Google-like response to list searches.  Pulling all items from a million+ record table to populate a search list isn't really practical.

    The link I had posted was slightly different than the one you provided.  Same article though.

    http://www.telerik.com/support/kb/winforms/details/server-side-auto-complete-for-raddropdownlist

  7. Hristo
    Admin
    Hristo avatar
    716 posts

    Posted 16 Jun Link to this post

    Hi Charles,

    Thank you for writing back.

    I am glad that the suggested approach in the KB resource fits your scenario. Regarding the links, indeed, they point to the same article.

    Should you have further questions please do not hesitate to write back.

    Regards,
    Hristo Merdjanov
    Telerik
    Check out the Windows Forms project converter, which aids the conversion process from standard Windows Forms applications written in C# or VB to Telerik UI for WinForms.For more information check out this blog post and share your thoughts.
Back to Top
UI for WinForms is Visual Studio 2017 Ready