Results 1 to 2 of 2

Thread: Fill combobox with data from MySQL tables

  1. Nov 29th, 2009, 05:16 PM #1
    Untouchab1e
    Untouchab1e is offline

    Thread Starter
    Lively Member
    Join Date
    Aug 2006
    Posts
    115

    Fill combobox with data from MySQL tables

    I have a combobox in my form which I want to fill with data from one column in an SQL database. Any idea on how I do this?

    Kind Regards
    Reply With Quote Reply With Quote
  2. Nov 29th, 2009, 07:29 PM #2
    jmcilhinney
    jmcilhinney is offline
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    111,221

    Re: Fill combobox with data from MySQL tables

    Query the database and populate a DataTable, then bind the DataTable to the ComboBox using its DataSource and DisplayMember properties. If you're not sure how to query the database then follow the Database FAQ link in my signature for information.

    Note that there is a MySQL-specific ADO.NET provider available for download from the MySQL web site.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width