ALTER PROCEDURE [dbo].[UIPKGUSER_spVerifyCredentials] @inUsername varchar(100), @inPassword varchar(100), @outUserCount int output, @outRoleName varchar(100) output AS BEGIN SET NOCOUNT ON; select @outUserCount = COUNT(*) from tbluser where username = @inUsername and password = @inPassword; if (@outUserCount > 0) begin select @outRoleName = rolename from tbluser where username = @inUsername and password = @inPassword; end else SET @outRoleName = ''; END
HERE IS CONNECTION string :-
DatabaseHelper.ConnectionString = ConfigurationManager.ConnectionStrings["DefaultDB"].ConnectionString;
SEND ME LOGIN Right Code
This is Table