How to set mySQL data source for combo box (C#)

Question

I am a beginner at C# and am having some serious issues setting the data source of a combo box. What I want to have happen is as follows: I want the combo box on my C# windows forum to be populated with the string names in just one column of a table in my mySQL database.

The mySQL table has the following format:

river_id, river_name, ....... (other columns) 
_____________________________________________
1           river1
2           river2         
3           river3
4           river4
5           river5
6           river6

What I want to happen is have the combo box be populated with each river name. Here is my attempt:

 string query = "SELECT * FROM sources";
       MySqlDataAdapter riverSourcesAdapter = new MySqlDataAdapter(query,connectionString);
       DataSet riverDataSet = new DataSet();
       riverSourcesAdapter.Fill(riverDataSet);

       comboBox1.Text = riverDataSet.Tables[0].Rows[0][0].ToString();

I also tried setting the combo box datasource and datamember in the designer instead, but that approach did not seem to work either.

Hamlet Hakobyan · Accepted Answer · 2014-06-27 19:13:38Z

3

Try this:

comboBox1.DataSource = riverDataSet.Tables[0];
comboBox1.DisplayMember = "<column name>";
comboBox1.ValueMember = "<column name>";

answered Jun 27, 2014 at 19:13

Hamlet Hakobyan

33.5k6 gold badges55 silver badges70 bronze badges

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

2 Comments

Hooplator15 Over a year ago

Well that was simple..... It works perfectly, thank you! Could you explain the need for the '<>' symbols please?

Hamlet Hakobyan Over a year ago

this is just placeholder for real column name :)

Ramgy Borja · Accepted Answer · 2017-08-04 07:15:58Z

0

your code should be like this..

comboBox1.DataSource = riverDataSet;
comboBox1.DisplayMember = "river_name";
comboBox1.ValueMember = "river_id";
comboBox1.SelectedIndex = -1;
comboBox1.AutoCompleteMode = AutoCompleteMode.Append;
comboBox1.AutoCompleteSource = AutoCompleteSource.ListItems;

answered Aug 4, 2017 at 7:15

Ramgy Borja

2,4682 gold badges24 silver badges41 bronze badges

Collectives™ on Stack Overflow

How to set mySQL data source for combo box (C#)

2 Answers 2

2 Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related