ASP.NET

ASP.NET RSS

Need Stored Procedure "sp_ValidateUser" for Login Page

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Jul 2007

Posts: 4

Reputation: yasinirshad is an unknown quantity at this point

Solved Threads: 0

yasinirshad yasinirshad is offline

Offline

Newbie Poster

Need Stored Procedure "sp_ValidateUser" for Login Page

Jul 2nd, 2007

Hi,

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

Thanks.

•

Join Date: Aug 2006

Posts: 812

Reputation: arjunsasidharan is on a distinguished road

Solved Threads: 13

arjunsasidharan arjunsasidharan is offline

Offline

Practically a Posting Shark

Re: Need Stored Procedure "sp_ValidateUser" for Login Page

Jul 3rd, 2007

•

Originally Posted by yasinirshad

Hi,

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

Thanks.

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
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
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.

There is just two ways to live your life.
One is as though nothing is a miracle.
The other is as if everything is.

Quick Reply to Thread

Show Printable Version

Similar Threads

Updated : Simple ASP.Net Login Page (ASP.NET)
database driven login page (ASP.NET)
Need Stored Procedure "sp_ValidateUser" for Login Page (C#)
Simple ASP.Net Login Page (Using VB.Net) (ASP.NET)

Other Threads in the ASP.NET Forum

Previous Thread: Google Checkout
Next Thread: Adding color to GridView

Thread Tools	Search this Thread
Show Printable Version Email this Page

You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.

Related Forum Features

ASP.NET Forum

Web Development Forum

ASP.NET Upvoted Threads (11)

ASP.NET Solved Threads (732)

ASP.NET News Stories (3)

ASP.NET Code Snippets (7)

ASP.NET Forum Search

Latest ASP.NET Posts

Today's Posts
Unanswered Threads

DaniWeb Message

Cancel Changes