C# combo box value and display using invoke method

Question

I am using Windows Forms, and I have a combo box with the values:

Apple
Oranges
Pairs

My text box contains values 1, 2 and 3,

apple = 1 and oranges = 2 and pairs = 3.

This relation is in my table on SQL, fields Account and Name. How do I change the value of the textbox to = 2 if the combo box is selected as oranges?

Basically this is reference to a program I'm working on that has an account combo box that displays the accounts names (user friendly). I need the names ID account number to then be displayed in the text box. From this text box I can then pass the value into my stored procedure that will get all the information on that account.

Update

The above text is out of date. See below!

A note to add is that my code gets the account details and populates my combo box.

Is there an easy way to do this? Or does this require joining in C# similar to SQL joins on tables?

Or without using a text box at all, basically my combo would have 2 fields orange, 2 but only display oranges to the user, but my other method uses the second field 2.

OK, so this part adds the acc field to the combo box.

{
    SqlCommand accountFill = new SqlCommand("SELECT name, acc FROM dbo.Customer", conn1);
    SqlDataReader readacc = accountFill.ExecuteReader();

    while (readacc.Read())
    {
        AddItem(readacc.GetString(0).ToString(), readacc, "name", "acc");
    }
    conn1.Close();
}

Add item is an invoke method used by my task.

private void AddItem(string value, Object dataSource, string name, string acc)
{
    if (accCollection.InvokeRequired)
    {
        accCollection.Invoke(new Action<string,Object,string,string>(AddItem), new Object[] { value });
    }
    else
    {
        //accCollection.Items.Add(value);
        accCollection.DataSource = dataSource;
        accCollection.DisplayMember = name;
        accCollection.ValueMember = acc;
    }
}

ERROR complex databinding accepts as a datasource iether an i.list or an i.list source at datasource.

It's such a broad question that people will have difficulty in giving you the exact answer that you may want. Simply put your application should have a data layer that deals with all of your database interaction. This layer then provides data classes to your main application, business logic using a defined interface. The data class itself can contain the user readable Username and the UserID (from your datatable). These are then bound in someway to your UI interface, whic should be decoupled as much as possible from the business logic. It's tempting to place DB access code directly into the UI — ChrisBD
Here's a similar post that may help stackoverflow.com/questions/2209290/… — user1231231412
@ChrisBD Yes if this was an MVC approach, but as it was a old Winforms Approach Applying MVC For the application Wasn't wanted or needed by the boss. (had this of been asp.net MVC app, then of course) — lemunk

Mahmoud Gamal Mahmoud Gamal · Accepted Answer · 2011-12-14T13:50:24

The ComboBox class has two properties ValueMember and DisplayMember. You need to set the DisplayMember property to the Names of your table or data, i. e. orange, apple, etc... ,and set the ValueMember property to the Id's of them:

combobox1.Datasource = readacc;
combobox.DisplayMember = 'name';
combobox.ValueMember = 'acc';

All you need then is just use the two properties SelectedValue to get the Id or SelectedText to get the value. For example, you could get the id of the selected item by using ComboBox.SelectedIndexChanged Event like this:

private void ComboBox1_SelectedIndexChanged(object sender, 
    System.EventArgs e)
{
    textbox2.text = int.parse(combobox1.SelectedValue.ToString());
}

or you can get the select text like:

textbox2.text = combobox1.SelectedText;

C# combo box value and display using invoke method

Update

2 Answers