I Have A Problem With The Stored Procedure To Login

Hi iam working with a login form.

When the member completes the registration the details like username,pwd and role i.e Admin or User will be stored in the database,later when the member login again it must check with the username and pwd and must get the role as output and must open the particular pages.I have two different home pages for Admin and User so if the member is admin by role then only admin home page must be opened and if he is user then directly user home page must be opened,

please help me with the stored procedure.

the procedure which i had written is:

Alter procedure LoginCheck(

@Username nvarchar(50), @Password nvarchar(50),

@Role nvarchar(MAX) output

)

AS

BEGIN

SET NOCOUNT ON ; IF EXISTS(SELECT Login_Role FROM RegistrationDetails WHERE Login_Uname = @Username and Login_Pwd=@Password)

BEGIN SELECT @Role = Login_Role FROM RegistrationDetails WHERE Login_Uname = @Username and Login_Pwd=@Password

END

SET NOCOUNT OFF

END

 

But this will just get the role as output but later how to get the related webforms depending on the role.

please help me with this..