求一个包括事物的存储过程，asp.net三层结构!

Question

求一个包括事物的存储过程，asp.net三层结构!
分不够在加，就这点分了

Answer 1

MS的Asp.net Starter Kit的例子。
http://www.microsoft.com/china/msdn/events/webcasts/shared/webcast/episode.aspx?newsID=1242103

Answer 2

http://www.cnblogs.com/lovecherry/archive/2005/04/11/135365.html看看

Answer 3

CREATE PROCEDURE sp_Login
( @tintSwitch tinyint,
@UserId varchar(50),
@UserPWD varchar(50),
@IntRight int,
@EmployeePositon varchar(50),
@UserName varchar(50),
@Employeeage varchar(50)

)
AS
   begin SET NOCOUNT ON
BEGIN TRANSACTION
IF @tintSwitch = 0
begin
insert into Login(
UserId,
UserPWD,
IntRight,
EmployeePositon,
UserName,
Employeeage

)
values( 
@UserId,
@UserPWD,
@IntRight,
@EmployeePositon,
@UserName,
@Employeeage


)
IF @@ROWCOUNT = 0 OR @@ERROR <> 0 GOTO DUPERR
   end
ELSE
BEGIN
UPDATE Login    SET
UserId=@UserId,
UserPWD=@UserPWD,
IntRight=@IntRight,
EmployeePositon=@EmployeePositon,
UserName=@UserName,
Employeeage=@Employeeage     WHERE UserId=@UserId
  IF @@ROWCOUNT = 0 OR @@ERROR <> 0 GOTO FAILEDend
COMMIT TRANSACTION    RETURN (0) -- Successful
--------------------------------------
FAILED: -- Failed
ROLLBACK TRANSACTION  RETURN (1)
  --------------------------------------
DUPERR: -- Insert Error 
ROLLBACK TRANSACTION
RETURN (2)
--------------------------------------
DELERR: -- Delete Error
ROLLBACK TRANSACTION
RETURN (3)
--------------------------------------
EDITERR: -- Edit Error 
ROLLBACK TRANSACTION 
RETURN (4) 
-------------------------------------- 
FKERR: -- ForeignKey Error 
ROLLBACK TRANSACTION
RETURN (5)
end
GO