Multiple Insert in ORACLE

Question

hello,
         does anybody know how to insert data into multiple tables on a single button click event?
EG:
i have 2 tables namely:
table1:
columns: empid,ename where empid is the primary key
and table2:
columns:empid,empcity where empid is the foreign key.

now what i want to do is i have created a form in asp.net
 wherein i take the input of all these column details.And on the click of insert button i want to insert data into those tables.What is the procedure to be followed in C# code?
Should we use stored procedures?
But it is also not working.
Please Help
thank you.