Paladine
can you attach the file and database it will be more helpful

HI
i used the sql database and i did your code my problem is all the input give me the message invalid passward although it is stored in the database.

the sql code work fine but give me invild message with any input eather wrong or right

Are you using Visual Studio or Web Matrix?

If you are using Visual Studio, have you stepped though the code?

Comment out the Invalid Login portion of the code and see what error message you are getting from ASP.Net

Yes i am using Visual Studio?
but can you attach your file it may help in my stiuation
thanks

Hi
THANKS FOR Paladine for nice code
did any one try the sql code it doesn't work with me
no error but the invalid message display all the time with any input?
if any one try the sql and it work can help me ????????????

thanks again for help

Anyone that would be so kind and post the stored procedure, I'm not able to get the northwind SP, and would therefore be happy if someone could show it, as i will try to get it up and running on a MS SQL 2000 server.

I'm trying with this so far:

CREATE PROCEDURE sp_ValidateUser
@UserName varchar(16), @Password varchar(16)
AS
SELECT COUNT(*) as Num_of_Users
FROM USERS
WHERE Users.username LIKE @UserName AND Users.password LIKE @Password

it returns 1 column as Num_of_Users with a either 1 or 0 depending on valid or invalid user/password


The login form ends up just saying "Invalid Login, please try again!"


Regards
Train

I did manage to create the SP myself. If anyone has the same problem this was what i wrote in my SP:

CREATE PROCEDURE sp_ValidateUser
@UserName varchar(16), @Password varchar(16)
AS
DECLARE @Num_of_User INT
SELECT @Num_of_User = COUNT(*) FROM USERS WHERE (Users.username LIKE @UserName) AND (Users.[password] LIKE @Password)
RETURN @Num_of_User

GO



Table's is abit diffrent compared to the exsampel, hope you can use it anyway

The start of the tutorial states where to find the basis on which this tutorial is built.

But here is the original Stored Procedure:

CREATE PROCEDURE sp_ValidateUser /* How it would appear in QUERY ANALYZER */
(
@UserName VARCHAR(50) = NULL,
@Password VARCHAR(50) = NULL,
@Num_of_User INT = 0
)
AS
SET @Num_of_User = (SELECT COUNT(*) AS Num_of_User
FROM NorthWindUsers
WHERE UserName = @UserName AND Password = @Password)
RETURN @Num_of_User



If you are still having troubles let me know...

Also one thing to note. I would avoid using LIKE as you will can have the chance of a guess working for the login, or even more likely to have multiple records.

A login should grab one, and only one record.