How Do I Add Information From 2 Different Tables

private void nbtnAddStaff_Click(object sender, EventArgs e)
        {
            try
            {
                string username = txtUserName.Text;
                string password = txtPassword.Text;
                string name = txtName.Text;
                string telephone = txtTelephone.Text;
                string phoneNumber = txtPhno.Text;
                string Address = txtAddress.Text;
                string role = comboBox1.SelectedItem.ToString();
                string eid = txtEid.Text;
                string officeAddress= txtOfficeAddress.Text;
                SqlConnection con = new SqlConnection("Data Source=AISASQITSVC02;Initial Catalog=DApp20140408;Integrated Security=True");
                string qr = "Insert into Equip_Person (Name,Address,Telephone_Number) values(@name,@address,@telephone_number)";
                string query="Insert into Equip_Employee(EID,OfficeAddress,PhoneExtNo,UserName,Password,Role) values(@EID,@OfficeAddress,@phoneNumber,@username,@password,@role)";
                SqlCommand cmd = new SqlCommand(qr, con);
                SqlCommand cmnd= new SqlCommand(query,con);
                cmd.Parameters.AddWithValue(@name, txtName.Text);
                cmd.Parameters.AddWithValue(@Address, txtAddress.Text);
                cmd.Parameters.AddWithValue(@telephone, txtTelephone.Text);
                cmnd.Parameters.AddWithValue(@eid, txtEid.Text);
                cmnd.Parameters.AddWithValue(@officeAddress, txtOfficeAddress.Text);
                cmnd.Parameters.AddWithValue(@username, txtUserName.Text);
                cmnd.Parameters.AddWithValue(@password, txtPassword.Text);
                cmnd.Parameters.AddWithValue(@phoneNumber, txtPhno.Text);
                cmnd.Parameters.AddWithValue(@role, comboBox1.SelectedItem.ToString());
                con.Open();
                int i = cmd.ExecuteNonQuery();

                if (i != 0)
                {
                    MessageBox.Show("Staff information added successfully");

                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }

        }