Get the Supplier ID of selected Supplier Name (combobox value) to appear in a textbox

Question

0.00/5 (No votes)

See more:

I'm trying to get the supplier id of the supplier name (combo box value) to appear in a textbox... can this code work?

C#

string query = "select * from Supplier WHERE SupplierName = '" + cbosupplier.SelectedValue.ToString() + "'";
              SqlCommand cmd = new SqlCommand(query, cn);
              cmd.CommandText = query;

              txtsupplierno.Text = query;

Posted 27-Jun-12 3:51am

wolfsor

Updated 27-Jun-12 3:56am

v3

Add a Solution

5 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)

OriginalGriff · Answer 1 · 2012-06-27T04:02:00

No.

Next question?

You have to execute the query, and use the resulting dataset - Oh, and please use parameterised queries. It help avoid accidental or deliberay damage to your database...
Try this:

C#

using (SqlConnection con = new SqlConnection(strConnect))
    {
    con.Open();
    using (SqlCommand cmd = new SqlCommand("SELECT Id FROM Supplier WHERE SupplierName = @SN", con))
        {
        cmd.Parameters.AddWithValue("@SN", cbosupplier.SelectedValue);
        using (SqlDataReader reader = com.ExecuteReader())
            {
            while (reader.Read())
                {
                int id = (int) reader[&quot;iD&quot;];
                }
            }
        }
    }

Tim Corey · Answer 2 · 2012-06-27T03:58:00

You are going to need to execute a reader, read the query results, and save the results into your property. I would look something like this:

C#

SqlDataReader rdr = cmd.ExecuteReader();

while (rdr.Read())
{
   txtsupplierno.Text =rdr["SupplierId"].ToString();
}

This would loop through each record and put that value into the text field, overwriting the last value. It isn't ideal if you are going to return more than one row but it gets the job done (quick and dirty first pass).

Next you need to think about protecting yourself against SQL injection. You should never pass a value from the UI straight into a SQL statement. The user could put code in the text box that would give them control over your database. If your combobox does not allow values to be typed in, you are safer, but I still like to see values to be inserted into statements using parameters.

Here is a good tutorial with more information that should help you out:

http://www.csharp-station.com/Tutorial/AdoDotNet/lesson03[^]

Mohammad Zare · Answer 3 · 2012-06-27T04:04:00

Solution 3

No you use datareader or datatable

Posted 27-Jun-12 4:04am

Mohammad Zare

John Bhatt · Answer 4 · 2012-06-27T04:16:00

This is your Code to Find SupplierID.

C#

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConName"].ConnectionString);
        SqlDataAdapter adp = new SqlDataAdapter("Select SupplierID from Suppliers where SupplierName = '" + cbosupplier.SelectedValue.ToString() + "'", con);
        DataSet ds = new DataSet();
        adp.Fill(ds);
        string SuppID = ds.Tables[0].Rows[0][0].ToString();

Mark as Answer if it helps you.

preet88 · Answer 5 · 2012-06-27T05:24:00

hi if i'm not wrong than you must be having this drop down which displays list of suppliers and you want to display its corresponding Id.

so to do this you should Bind the dropdown display text with the name of suppliers
and bind dropdowns value member with the id of suppliers.
it is possible to have two different fields binded with the same dropdown

after this there is no need to execute select command
you can to so as following
txtsupplierno.Text = cbosupplier.SelectedValue;

while cbosupplier.SelectedText will display the suppliers name...

thanks
hope the suggestion helps you.

Get the Supplier ID of selected Supplier Name (combobox value) to appear in a textbox

5 solutions

Solution 2

Solution 1

Solution 3

Solution 4

Solution 5

Add your solution here

Preview 0