Hi All,
I have a stored procedure that has output value:
Alter PROCEDURE [dbo].[newUser]
@UserName nvarchar(256),
@Password nvarchar(128),
@Email nvarchar(256),
@PasswordQuestion nvarchar(256),
@PasswordAnswer nvarchar(256),
@LastActivityDate DATETIME,
@CreateDate DATETIME,
@UserId uniqueidentifier OUTPUT
AS
BEGIN
IF( @UserId IS NULL )
SELECT @UserId = NEWID()
ELSE
BEGIN
IF( EXISTS( SELECT UserId FROM dbo.tblUsers
WHERE @UserId = UserId ) )
RETURN -1
END
INSERT dbo.tblUsers ( UserName, Password,Email, PasswordQuestion,PasswordAnswer, LastActivityDate,CreateDate)
VALUES ( @UserName, @Password,@Email, @PasswordQuestion,@PasswordAnswer, @LastActivityDate,@CreateDate)
RETURN 0
END
then my .net code here:
using System;
using System.Collections;
using Sy ...
Go to the complete details ...