Member Avatar for yasinirshad

Hi,

Can anyone send me the Stored Procedure for "sp_validateUser" for login page using asp.net 1.1

Thanks.

  • 2 Contributors
  • 1 Reply
  • 63 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by arjunsasidharan
Member Avatar for arjunsasidharan

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.