Select Value from combo box and according to that value data will be load from the database?

Question

0.00/5 (No votes)

See more:

the code is for select value from Usertype combo box
combo box contain values like (hr, production, executive) like that.

if someone select hr, next combo box will load all employees related to hr from sql database

Combo box names = UserType_CMBbox , UserName_CMBbox

C#

{
            String Usertype = UserType_CMBbox.SelectedValue.ToString();
            //Select User Type from user type Combo box

            UserName_CMBbox.Items.Clear();
            DataSet ds = new DataSet();
            ds.Clear();
            SqlConnection con = new SqlConnection();
            con.ConnectionString = "Data Source=PROMOD-PC;Initial Catalog=Unicella_Data;Integrated Security=True";
            con.Open();
            SqlDataAdapter adpi = new SqlDataAdapter("Select distinct User_Name from Login_Table Where User_Type='" + Usertype + "'", con);
            adpi.Fill(ds);
            UserName_CMBbox.DataSource = ds.Tables[0];
            UserName_CMBbox.DisplayMember = "User_Name";
            con.Close();
        }

the problem is data will not load into the other combo box

Posted 4-Nov-13 10:44am

promod madushan

Add a Solution

Comments

Kschuler 4-Nov-13 17:11pm

What kind of project is this? Win forms? Web? (Please click the Improve question and add tags to your question to specify this) What is a UserType_CMBbox? And you really should look into using parameters instead of directly concatting values into your SQL statement.

BulletVictim 5-Nov-13 0:51am

SqlDataAdapter adpi = new SqlDataAdapter("Select distinct User_Name from Login_Table Where User_Type='" + Usertype_CMBox.SelectedItem.ToString() + "'", con);

Should fix the problem you have

1 solution

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)

Mohan Gopi · Accepted Answer · 2013-11-05T00:36:00

Hi Promod,

Try this,

C#

  String Usertype = UserType_CMBbox.SelectedValue.ToString();
   //Select User Type from user type Combo box

   UserName_CMBbox.DataSource = null;
   DataSet ds = new DataSet();
   SqlConnection con = new SqlConnection();
   con.ConnectionString = "Data Source=PROMOD-PC;Initial Catalog=Unicella_Data;Integrated Security=True";
   con.Open();
   SqlDataAdapter adpi = new SqlDataAdapter("Select distinct User_Name from Login_Table Where User_Type='" + Usertype + "'", con);
   adpi.Fill(ds);
   UserName_CMBbox.DataSource = ds.Tables[0];
   UserName_CMBbox.DisplayMember = "User_Name";
   con.Close();

I hope this will help you.

Thank's
Mohan G