Add or insert records to multiple tables in SQL 2008 using C #

See more:

C#

Hi all,

Please advice me on how to insert or add records to multiple tables in sql 2008 using c sharp.

Table1 is EMPLOYEES
Table2 is BIRTHDAY

The record gets added to table1 perfectly, I want it to be added to table2 simultaneously.
below is the code which I am using

private void btnAdd_Click(object sender, EventArgs e)
        {
            SqlConnection DB_Connection = SQLConnect.Instance;
            SqlDataAdapter da = new SqlDataAdapter();            
            da.InsertCommand = new SqlCommand("INSERT INTO EMPLOYEES VALUES(@EMPID, @NAME, @DOB)", DB_Connection);
            
            if (string.IsNullOrEmpty(textBox1.Text))
            {
                MessageBox.Show("Please Fill in the Employee ID");
                textBox1.Focus();
                da.InsertCommand.Parameters.Add("@EMPID", SqlDbType.NVarChar).Value = DBNull.Value;
            }
            else
            {
                da.InsertCommand.Parameters.Add("@EMPID", SqlDbType.NVarChar).Value = textBox1.Text;
            }
           
           if (string.IsNullOrEmpty(textBox2.Text))
            {
                MessageBox.Show("Please Fill in the Employee Name");
                textBox2.Focus();
                DB_Connection.Close();
                //da.InsertCommand.Parameters.Add("@NAME", SqlDbType.NVarChar).Value = DBNull.Value;                
            }
            else
            {
                da.InsertCommand.Parameters.Add("@NAME", SqlDbType.NVarChar).Value = textBox2.Text;
            }
		
	    if (string.IsNullOrEmpty(dateTimePicker1.Text))
            {
                da.InsertCommand.Parameters.Add("@DOB", SqlDbType.Int).Value = DBNull.Value;
            }
            else
            {
                da.InsertCommand.Parameters.Add("@DOB", SqlDbType.Date).Value = dateTimePicker1.Value;
            }
System.Windows.Forms.TextBox sj = new TextBox();
            try
            {
                if (sj.Text.Length >= 0)
                {
                    MessageBox.Show("yes proceed");
                    DB_Connection.Open();
                    int ins = da.InsertCommand.ExecuteNonQuery();                    
                    MessageBox.Show(ins.ToString() + " Record Inserted to DB");
                    ClearForm(this);                    
                    DB_Connection.Close();
                }
                else
                {
                    MessageBox.Show("Fill in all the Details");
                }
            }
            catch (Exception yu)
            {
                MessageBox.Show(yu.Message);
            }