how to add options in combobox in C# from mysql database column

Question

I have a combo box in my windows application form. I have a table called menu-list in a MySQL database. When i click on the combo box i want the options to be the value of a particular row of the database table for example a row called wine has 2 values, for example red wine and white wine, so when i click on the combo box i want the options to be red wine and white wine

private void menustart_Load(object sender, EventArgs e)
{
    // TODO: This line of code loads data into the 'cmsDataSet.menulist' table. You can move, or remove it, as needed.
    this.menulistTableAdapter.Fill(this.cmsDataSet.menulist);

}

I used the above code but it didnt work

igore that i was just copy pasting something from the net which didn't workout.. could you help me with an easier way to achieve my desired result — Brian
– Brian, Commented Mar 7, 2014 at 12:19

Community · Accepted Answer · 2017-05-23 11:49:45Z

1

Maybe some of these posts might help you to get a solution :

Solution 1
Solution 2
Solution 3

Try these and let me know if you could find a solution.

EDIT : Try this code.

string MyConString = "SERVER=localhost;" +
                     "DATABASE=yourDB;" +
                     "UID=root;" +
                     "PASSWORD=yourPassword;";
MySqlConnection connection = new MySqlConnection(MyConString);
string command = "select wine from menu-list";
MySqlDataAdapter da = new MySqlDataAdapter(command,connection);
DataTable dt = new DataTable();
da.Fill(dt);
foreach (DataRow row in dt.Rows)
{
   string wine = string.Format("{0}", row.Item[0]);
   yourCombobox.Items.Add(wine);
}
connection.Close();

edited May 23, 2017 at 11:49

CommunityBot

11 silver badge

answered Mar 7, 2014 at 12:21

Hyarantar

2171 silver badge12 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Brian Over a year ago

thanks alot worked perfectly as i wanted..there is another thing that i wanted to do.. could you tell me how to add these values retrived from the database as a checkbox option within a combobox.

Hyarantar Over a year ago

@Brian I don't understand... What do you want to do ? Could you be more specific about your question ? Do you want to do the same for checkboxes ?

Brian Over a year ago

ya sure now in the solution which u provided every value from the database table is going into the combo box from which i can select only 1 value. i need to select multiple values from the combo box(ie try to 1st convert those values into a check box list and then but that check box list in the combo box) is that possible?? o is there any alternate solution

Hyarantar Over a year ago

@Brian I think what you're trying to do might be solved here, it is using ComboBox, and they put some CheckBox within the ComboBox. codeproject.com/Articles/563862/Multi-Select-ComboBox-in-WPF

Collectives™ on Stack Overflow

how to add options in combobox in C# from mysql database column

1 Answer 1

4 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related