Dear Friend
If the two operations need to be completed simultaniously then i would suggest you to use
stored procedures
pass values as argument and execute it
da.InsertCommand = new SqlCommand("EmployeeInfoInsert(@EMPID, @NAME, @DOB)", DB_Connection);
:
:
:
-------Stored Procedure ---------
createprocedure EmployeeInfoInsert(@EMPID varchar(20), @NAME varchar(20), @DOB datetime)
as
begin
insert statement to EMPLOYEE table
insert satatement to BIRTHDAY table
end