Click here to Skip to main content
12,998,759 members (70,722 online)
Rate this:
Please Sign up or sign in to vote.
See more:
i have a form with a comboBox, a textBox, and a button. the comboBox shows items from an sql database using dataBindingSources. after filling the textBox and clicking the button, a new item is added to this database, but i can't see this new item in the comboBox until i close and re-open the windowsForm. how to refresh the comboBox without close/re-open???

here's the code:

private void button2_Click(object sender, EventArgs e)
                SqlConnection myConnection = new SqlConnection("****");
                    SqlCommand myCommand = myConnection.CreateCommand();
                    myCommand.CommandText = "INSERT INTO Items (NameItem) " +
                "Values ('" + textBox2.Text + "')";
                    MessageBox.Show("Item Added", "OK");
                catch (SqlException exp)
Posted 6-May-13 9:04am
richcb 6-May-13 15:08pm
I would recommend re-binding the datasource in your "finally". That will have the combobox repopulate with the new data.
Naourass Derouichi 6-May-13 15:28pm
How to rebind?

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Rebind the combo box in your button click event, after adding the item.
Naourass Derouichi 6-May-13 15:28pm
how to rebind?
Teenustar 6-May-13 15:35pm
How did you bind the combo box in the form load? Similarly.
Naourass Derouichi 10-May-13 13:49pm
i binded my combobox by clicking on the combobox arrow and checking use data elementsthen selecting the db and the table.That was in the form design!
Teenustar 10-May-13 14:45pm
Yes. Thats one way of doing it. But there are other ways. Please refer
Naourass Derouichi 11-May-13 12:58pm
ok thannks

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170622.1 | Last Updated 6 May 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100