Click here to Skip to main content
15,884,838 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
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:

C#
private void button2_Click(object sender, EventArgs e)
        {
            {

                SqlConnection myConnection = new SqlConnection("****");
                myConnection.Open();
                
                try
                {
                    SqlCommand myCommand = myConnection.CreateCommand();
                    myCommand.CommandText = "INSERT INTO Items (NameItem) " +
                "Values ('" + textBox2.Text + "')";

                    myCommand.ExecuteNonQuery();
                    MessageBox.Show("Item Added", "OK");
       
                }
                catch (SqlException exp)
                {
                    MessageBox.Show(exp.Message);
                }

                finally
                {
                    
                    myConnection.Close();
                    textBox2.Clear();
                    
                    
                }
              
            }
Posted
Comments
Richard C Bishop 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.
Nnorss 6-May-13 15:28pm    
How to rebind?

1 solution

Rebind the combo box in your button click event, after adding the item.
 
Share this answer
 
Comments
Nnorss 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.
Nnorss 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 http://msdn.microsoft.com/en-us/library/w67sdsex.aspx
Nnorss 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)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900