hi
i have written stored procedure which fetch username and password from two tables
1)SuperAdmin_Details Columns: Id Username password
2)LoginInfo_Details columns: MyId Username Password
my stored procedure is:
ALTEr PROCEDURE SpLogin
@Username varchar(50),
@Password varchar(50),
@ID int output
AS
BEGIN
if (@Username ='')
BEGIN
SET @ID =1
END
ELSE IF (@Password='')
BEGIN
SET @ID =2
END
ELSe if (exists(select Id from SuperAdmin_Details WHERE Username=@Username AND Password =@Password ))
BEGIN
SET @ID =3
END
ELSe IF (Exists(select Username FROM LoginInfo_Details WHERE Username=@Username AND Password=@Password ))
BEGIN
SEt @ID =4
END
ELSE
BEGIN
SEt @ID =5
END
END
after that i want to pass id on another page which i have select
< ...
Go to the complete details ...