Click here to Skip to main content
11,922,381 members (31,743 online)
Rate this:
Please Sign up or sign in to vote.
See more: C# SQL-Server VS2012
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 10: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
0 OriginalGriff 453
1 Dave Kreskowiak 335
2 Sergey Alexandrovich Kryukov 263
3 Richard MacCutchan 225
4 ppolymorphe 175
0 OriginalGriff 7,231
1 KrunalRohit 4,530
2 Sergey Alexandrovich Kryukov 3,356
3 George Jonsson 2,865
4 Suvendu Shekhar Giri 2,216

Advertise | Privacy | Mobile
Web03 | 2.8.151120.1 | Last Updated 6 May 2013
Copyright © CodeProject, 1999-2015
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