how to create a "create user name and password page"

[romtang]

I'm trying to create a page where customers can create their own unique user name and password. Then they use this to gain access to the site. Need to know how to use the asp database and all. Thought maybe I could just write the html but I guess I'm a little behind in knowledge.
Thanks for any and all info.
James

[thenmozhivasanraj]

First think you have to create the backend table with 3 columns
id - Auto increment
Username, varchar
Password varchar

then in front end you have to design the page with 2 textboxes and one button.
first textbox with normal text and next one should be in pass word text mode.

create a connection string in web config to access the databse.

On button click you have to save the datas which is entered by the user to databse table.

[Frinavale]

I'm trying to create a page where customers can create their own unique user name and password. Then they use this to gain access to the site. Need to know how to use the asp database and all. Thought maybe I could just write the html but I guess I'm a little behind in knowledge.
Thanks for any and all info.
James

You're going to have to look into what sort of authentication you're going to use for your project (I'm assuming this is a web application you're developing).

If you are using Visual Studio 2005 (.NET Framework 2.0), you can take advantage of the tools readily available to you. Check out this video on Membership, Roles, Forums Authentication, and Security. It moves quickly but you'll see how easy it is to set up an authentication system for your website.

If you cannot use this resource, get back to us and we'll help you through "the hard way"


:)
-Frinny

[romtang]

OKay that does help alot.
Next problem... When users fill out and submit a paticular form. Some way the next page needs to be the results of said form. But not just from the user submitting, but ALL users that have ever submitted with results listed in alphabetical order by last name.? Again any and all help is greatly appreciated!

[Frinavale]

OKay that does help alot.
Next problem... When users fill out and submit a paticular form. Some way the next page needs to be the results of said form. But not just from the user submitting, but ALL users that have ever submitted with results listed in alphabetical order by last name.? Again any and all help is greatly appreciated!

You're going to need to store your information in a database or other some other persistent storage. When the user submits a value, you should retrieve the data from the database (where everyone's submitted values are stored) and display it on the page.

Check out the GridView control. It will provide you with a nice "grid" type layout for your data and lets you add in sorting functionality along with paging etc. (There's some tutorials on how to use this control further down on the page I linked you to).

Cheers!
-Frinny