procedure to insert and delete using sql server 2008

Question

Need procedure for  insert two table at a time and truncate table
Like table1
Button1 I need to insert these two tables  in front end asp.net using c# (web application)
Date 18.8.13
Productname cement
Price 300
Extra 10  (310*14.5/100)=44.95
Vat 14.5/100
Total  354.95
 
Table2
 
Date
Productname: closeup
Price 50
Vat 14.5/100
Total  57.25
 
Button 2 click event I need to truncate table1