how to pull information from one table into text boxs based on primary key from another table? :  protected void custo_search_Click(object sender, EventArgs e)
        {

            conn.Open();

            if (appo_fname.Text != null || appo_lname.Text != null || appo_num.Text != null)
            {

                DataTable dt = new DataTable();
                MySqlDataReader myReader = null;
                MySqlCommand myCommand = new MySqlCommand("SELECT customers.First_name,customers.Last_name,customers.Phone_num From customers INNER JOIN appointments On customers.Phone_num=appointments.Phone_num Where customers.Phone_num='" + search_txt.Text+"' ", conn);
                myReader = myCommand.ExecuteReader();

                while (myReader.Read())
                 {  
                appo_fname.Text = (myReader["customers.First_name"].ToString());
                appo_lname.Text = (myReader["customers.Last_name"].ToString());
                appo_num.Text = (myReader["customers.Phone_num"].ToString());


                }
                conn.Close();
            }


Hi,
i am trying to connent between 2 tables with the same primary key,so when i put a phone number in search textbox it will check if the number exist in the  other table and if it is so i will get f.name,l.name and phone into other text boxs in order to insert the customer information without typing all over but somting is not working in my code,it skeep over the code inside the "while"