Reset ComboBox that reads from a db

Question

0.00/5 (No votes)

See more:

I have two combo box on my form (category and activity) that reads data from the db and display them in their DropDown. under category when I select Beauticians the activity ComboBox automatically fills it self with barber, hair dresser, and manicure but when I reselect construction in the category ComboBox massion, carpentry and plumber get added to the barber, hair dresser, and manicure which is for Beautician.

how do reset the activity ComboBox DropDown when a new category is selected

I tried this but did not work.

C#

this.cboType.Refresh();
this.cboType.Reset();

Posted 27-Jun-12 4:43am

mikeoabban

Updated 3-Oct-12 5:35am

WebMaster

v3

Add a Solution

3 solutions

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)

preet88 · Answer 1 · 2012-06-27T05:13:00

Solution 2

hi
write the folowing code to clear the data in combobox

C#

comboBox1.Items.Clear();

here combobox1 is an object of combobox.

hope this may resolve your problem.
thanks.

Posted 27-Jun-12 5:13am

preet88

Updated 3-Oct-12 5:29am

v2

Comments

mikeoabban 27-Jun-12 11:33am

thanks is it that simple. it worked

preet88 27-Jun-12 11:54am

:) your welcome
mark your question as solved by accepting answer it may help others as well.
thanks :)

Tim Corey · Answer 2 · 2012-06-27T04:59:00

It sounds like you are updating your second combo box manually after the first one is changed instead of having it bound directly to the database. If this is the case, set the DataSource to nothing before you add your new items. This should blank out your existing data.

Here is a Stack Overflow question that has more details on how to do this:
http://stackoverflow.com/questions/512385/combobox-refresh-after-adding-data-from-childform[^]

psychic6000 · Answer 3 · 2012-10-03T06:57:00

Solution 4

clear the older contents of your 2nd combo box

C#

cb2.items.clear();

then load new items in it based on it.

Posted 3-Oct-12 6:57am

psychic6000