C# MySql query result to combobox

Question

I'm trying to query an MySql table, put all results into a combobox.

So my query results in apple 2220
I want to populate the combobox with apple2220
i'm having trouble getting the string outside of datarow.

        string MyConString = "SERVER=localhost;" +
                "DATABASE=iie;" +
                "UID=root;" +
                "PASSWORD=xxxx;";
        MySqlConnection connection = new MySqlConnection(MyConString);
        string command = "select fruit,number from clientinformation";
        MySqlDataAdapter da = new MySqlDataAdapter(command,connection);
        DataTable dt = new DataTable();
        da.Fill(dt);
        foreach (DataRow row in dt.Rows)
        {
            string rowz = row.ItemArray.ToString();
        }
        connection.Close();

Hyperion · Accepted Answer · 2016-01-29 18:47:33Z

3

Try something along these lines:

...
foreach (DataRow row in dt.Rows)
{
   string rowz = string.Format("{0}:{1}", row.ItemArray[0], row.ItemArray[1]);
   yourCombobox.Items.Add(rowz);
}
....

edited Jan 29, 2016 at 18:47

Hyperion

9091 gold badge10 silver badges23 bronze badges

answered Mar 1, 2011 at 18:57

Klaus Byskov Pedersen

122k31 gold badges192 silver badges223 bronze badges

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

Comments

Bala R · Accepted Answer · 2011-03-01 19:06:16Z

2

Instead of

        foreach (DataRow row in dt.Rows)
        {
            string rowz = row.ItemArray.ToString();
        }

try this

comboBox1.DataSource = dt;
comboBox1.DisplayMember = "Fruit"; 
comboBox1.ValueMember = "Number";
comboBox1.DataBind();

edited Mar 1, 2011 at 19:06

answered Mar 1, 2011 at 19:00

Bala R

109k23 gold badges203 silver badges212 bronze badges

Collectives™ on Stack Overflow

C# MySql query result to combobox

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related