Inserting Values Into Multiple Tables

Hi All,
     am new to sql server in my application I am having one Asp.net web page, the user has to enter values for 5 fields(Empno,Empname,salary,deptno,deptname) in that web page and for that i created two tables in sql server
Emp Table- empno(primary key),empname,salary
Dept Table- Deptno(primary key),empno(Foreign key ),Deptname(with some check constraint.)
After the user enter all the values in the Asp.net web page now i want to store data into database for that i wrote
 the following stored procedure...


create procedure usp_EmpDept  
@empno integer,  
@empname varchar(15),  
@salary money,  
@deptno integer,  
@deptname varchar(10)  
As  
 
Insert into emp(empno,empname,salary)values(@empno,@empname,@salary)  
Insert into dept(deptno,Empno,deptname)values(@deptno,@empno,@deptname)  
 
but the problem is whenever some constaint violation for eg. if some check constraint violation in Dept table its inserting the values in the Emp table only, but my requirement is,  It must enter into both tables if there is no constaraint violation otherwise it has to ignore both the tables.  And also please suggest is there any better way to insert values into two tables other than using the stored procedure
 
Any help will be greatly appreciated..
Thanks,
Vision..