Logon Tutorial?

[jimmybambino]

I'm looking for a way to use SQL Server 2000, ASP.NET and Dreamweaver to create a secure logon. If possible I'd like to be able to have a user name and password table in SQL Server and then be able to logon to a site via an ASP.NET web site. Can someone help me accomplish this difficult task?

Thanks,
Jimbo

 

[Zarcom]

Jimmy this really isn't all that difficult. In fact it is something that happens quite frequently in the world of web programming.

Anyway. Create yourself a page with two text boxes. Set the one to password type so that the text will be *starred* out. Add a button to the page.

Set up a connection to the database, now depending what your users table looks like the next bit may vary some. The basic idea however, is to check to see if the username/password combo match any in the database. If they match allow the user access to your site, if not display an login error message.

How you secure the rest of your site is really up to you but if you use the forms authentication method built into .NET it's quite simple. You can find more info about that here:

http://msdn.microsoft.com/library/d...uide/html/cpconsimplecookieauthentication.asp

General info here:

http://msdn.microsoft.com/library/d...de/html/cpconaspnetwebapplicationsecurity.asp

That'l do donkey, that'l do
Mark
If you are unsure of forum etiquette check here faq796-2540