Try something like this:
MySqlConnection cs = new MySqlConnection(connectionSQL);
string query = "SELECT * FROM Teacher WHERE name= '" + comboBox1.SelectedValue + "'";
adapter = new MySqlDataAdapter(query, cs);
DataSet DS = new DataSet();
adapter.Fill(DS);
You will have to alter how you get your textboxes filled after the query.