[Not a question] C# Refresh Combo Box

Question

1.00/5 (2 votes)

See more:

, +

I have a combo box with data bounded from a Data Base. I am having problems when adding new items to database and also editing and deleting items. When I do those actions, The combobox is not getting updated until the app restart. I am just a student and I need help for this. I bounded the data through the option available in Visual Studio 2010.

Posted 11-Sep-13 4:08am

Kaveen Abeywansa

Updated 11-Sep-13 4:18am

Sergey Alexandrovich Kryukov

v2

Add a Solution

Comments

norbitrial 11-Sep-13 10:12am

Add the code for your question.

Sergey Alexandrovich Kryukov 11-Sep-13 10:18am

Sorry, this is not a question. And now: any effort?

Your "just a student" is absurd. The student is the one who study, not an excuse.

—SA

BulletVictim 11-Sep-13 10:20am

Most simplistic way I know of is: After you have added data to the database clear the items in the combobox and then run the bind again.
But as norbitrial said. We will need to see the code that is related to your problem.

Kaveen Abeywansa 11-Sep-13 10:23am

I am using the option available which will bind the data. I have coded for it. I used the arrow on the combobox to do so.

BulletVictim 11-Sep-13 10:27am

Honestly some advise since you are still a student, try to refrain from using the GUI option in data control as much as possible

3 solutions

Solution 2

Just googled for 2 seconds and found this:

C#

foreach (Control ctl in this.Controls)
{
    ctl.ResetBindings();
}

Posted 11-Sep-13 4:29am

Jean A Brandelero

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

norbitrial · Accepted Answer · 2013-09-11T04:18:00

Solution 1

It can be a good solution if you put into your form a refresh button and with it you can make a query for your database and rebind the data to your combobox.

Posted 11-Sep-13 4:18am

norbitrial

Comments

Member 10986425 29-Sep-15 4:15am

This is not proper way to solve problem it needs to be automatic no any inputs

Kaveen Abeywansa · Accepted Answer · 2013-09-14T23:11:00

Thanks for all who spent their time to help. Even I didn't get the answer, I found the way to do so. I will post it as a help to another beginner like me.

SqlConnection con = new SqlConnection(@"PATH");
con.Open();
SqlCommand cmd = new SqlCommand("select Field from TableName", con);
SqlDataAdapter SDA = new SqlDataAdapter();
SDA.SelectCommand = cmd;
DataTable DT = new DataTable();
SDA.Fill(DT);
comboBox1.DataSource = DT;
con.Close();