Create a Login page (asp,c#,sql2k5)

[mmjepp]

Hi!
First of all, im from sweden so my english isn't the best :!:..

I read a guide "How to make a simple login page" ..(something like that)
But i need help with my languages(aspx,C#,sql2k5)

The problem for me is how to make the SP for checking if Username and Password is correct... And also how to write the codes in the C# for that...

I have a "Create User"... a simple page where u write username and password then a SAVE button... When u hit the button it saves the info to my Sql database. (i have a SP for that)..

So the things I want help with is this:
* The stored procedure code for checking if user,pass is correct
* The C# code for the "login button" and connection with the Database
* And if login sucess the user get to a new page like index.asp

[brainbox]

Hi

I know that you would be getting this reply after quite a while of posting your question, but if you have not implemented it yet, then i am sure i can help. Now i will only give you the idea od how would you go about it, however, for the code you might have to wait over the weekend, as i would have to write and test it.

1 - you would take the username and password fromt he user
2 - then you would check them against the data you have in your database
3 - for database, you would have a connection and then a query
4 - so, if the query returns the correct result
5 - you would allow the user to see the next page,
6 - else you would prompt the user to enter username & password again

I hope this helps

Thanks

Hi!
First of all, im from sweden so my english isn't the best :!:..

I read a guide "How to make a simple login page" ..(something like that)
But i need help with my languages(aspx,C#,sql2k5)

The problem for me is how to make the SP for checking if Username and Password is correct... And also how to write the codes in the C# for that...

I have a "Create User"... a simple page where u write username and password then a SAVE button... When u hit the button it saves the info to my Sql database. (i have a SP for that)..

So the things I want help with is this:
* The stored procedure code for checking if user,pass is correct
* The C# code for the "login button" and connection with the Database
* And if login sucess the user get to a new page like index.asp