Hi,
Can anyone send me the Stored Procedure for "sp_validateUser" for login page using asp.net 1.1
Thanks.
CREATE PROCEDURE User_Login (@UserId AS VARCHAR(50),@Password AS VARCHAR(50)) --@Userid and @Password parameters from your client webpage
AS
BEGIN
SELECT
Userid,
Password
FROM
ApplicationUsers --Table name
where Userid = @Userid and
password = @password
GO
Don't know whether this will work. Make some modifications according to your need.
Reputation Points: 347
Solved Threads: 13
Practically a Posting Shark
Offline 812 posts
since Aug 2006
Unsolved 
