Using a selection from a combobox to display a different database column in a textbox

See more:

C#

SQL

I have a combobox attached to an SQL database that pulls the data I need, however I want it to display a different column in that same db row in a textbox based on what was selected in the Combobox.

My combobox is working perfectly displaying all the information I need. Just need to display the 4th column in a textbox based on combobox selection.

DB breakdown: inside my table I have 4 columns:
Name
Direction
number
ipaddress

When select an item in my combobox I want it to display the ipaddress in a textbox named textbox1.


Thank you,

What I have tried:

void Fillcombo()
        {
            string constring = "Data Source=DATABASEHERE;Initial Catalog=HERE;User ID=USERIDHERE;password=PASSWORDHERE";
            string Query = "select * from TABLEHERE;";
            SqlConnection conDataBase = new SqlConnection(constring);
            SqlCommand command = new SqlCommand(Query, conDataBase);
            try
            {
                conDataBase.Open();
                SqlDataReader myReader = command.ExecuteReader();

                while (myReader.Read())
                {
                    string lName = myReader["Name"].ToString();
                    string dirName = myReader["Direction"].ToString();
                    string midName = myReader["number"].ToString();
                    comboBox2.Items.Add(lName + " " + dirName + " " + midName);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

private void ComboBox2_SelectedIndexChanged(object sender, EventArgs e)
        {
            string constring = "Data Source=DATABASEHERE;Initial Catalog=HERE;User ID=USERIDHERE;password=PASSWORDHERE";
            string Query = "select * from TABLEHERE where Name='" + comboBox2.SelectedValue + "'";
            SqlConnection conDataBase = new SqlConnection(constring);
            SqlCommand command = new SqlCommand(Query, conDataBase);
            try
            {
                conDataBase.Open();
                SqlDataReader myReader = command.ExecuteReader();

                while (myReader.Read())
                {
                    string ipName = myReader["ipaddress"].ToString();
                    textBox1.Text = ipName;
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }