populate combo box in c#

Question

0.00/5 (No votes)

See more:

I dont know how to populate combobox in c# by resault set of select statement of sql
for example for gender male and female. plz help me tanx

Posted 23-Feb-13 21:37pm

Hodamdi

Add a Solution

Comments

Sandeep Mewara 24-Feb-13 4:31am

This is not a well framed question! We cannot work out what you are trying to do/ask from the post. Please elaborate and be specific.
Use the "Improve question" link to edit your question and provide better information.

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)

Shobhana.n · Answer 1 · 2013-02-24T02:51:00

Try this:

C#

string strConn = "Data Source=SEZSW08;Initial Catalog=Nidhi;Integrated Security=True";
        SqlConnection Con = new SqlConnection(strConn);
        Con.Open();
        string strCmd = "select companyName from companyinfo where CompanyName='" + cmbCompName.SelectedValue + "';";
        SqlCommand Cmd = new SqlCommand(strCmd, Con);
        SqlDataAdapter da = new SqlDataAdapter(strCmd, Con);
        DataSet ds = new DataSet();
        Con.Close();
        da.Fill(ds);
        cmbCompName.DataSource = ds;
        cmbCompName.DisplayMember = "CompanyName";
        cmbCompName.ValueMember = "CompanyName";
        //cmbCompName.DataBind();
        cmbCompName.Enabled = true;

If it is a drop down then use

C#

ddlCompName.Datasource=ds;
ddlCompName.Datavaluefield="CompanyName";
ddlCompName.DataTextfield="CompanyName";
ddlCompName.DataBind();

[Edit]Code blocks added[/Edit]

Abdisamad Khalif · Answer 2 · 2013-02-24T04:57:00

Try Something like this
--------------------------

<pre> private void Form1_Load(object sender, EventArgs e)
        {
            //Making Sql Connection
            SqlConnection cn = new SqlConnection();
            //Setting Connection String Property
            cn.ConnectionString = "data source = (local); initial catalog = TestDB; integrated security =sspi";
            //Opening Connection
            cn.Open();

            //Creating Sql Command
            SqlCommand cmd = new SqlCommand();
            //Creating String Variable for SQL Command CommandProperty
            string sqlQuery = "select GenderID,GenderType from Gender";
            //Passing Query and Connection to the SQL Command
            cmd = new SqlCommand(sqlQuery, cn);
            //Creating Sql Data Adapter
            SqlDataAdapter dAdapter = new SqlDataAdapter();
            //Creating Data Table
            DataTable dt = new DataTable();
            //Initializing SQL Data Adapter Command Property
            dAdapter.SelectCommand = cmd;
            //Filling Data Table
            dAdapter.Fill(dt);
            //Populating Combo Box from Data Table
            cmbGender.DataSource = dt;
            //Setting Combo Box ValueMember Property
            cmbGender.ValueMember = "GenderID";
            //Setting Combo Box DisplayMember Property
            cmbGender.DisplayMember = "GenderType";

        }</pre>

S. M. Ahasan Habib · Answer 3 · 2013-02-24T04:21:00

Solution 2

In practice you should not write any sql statement/execute database command from directly your presentation layer. You should write all that in dataaccess layer and return custom entity from that layer. From presentation layer you get that data by Business Layer and bind it with your drop down list.

Posted 24-Feb-13 4:21am

S. M. Ahasan Habib

Comments

Hodamdi 26-Feb-13 1:49am

Tanks for your solutions

populate combo box in c#

3 solutions

Solution 1

Solution 3

Solution 2

Add your solution here

Preview 0