Creating Database for your site's users

I'm pretty new to creating a database, and especially how to use it on discountasp.net.

I'm using Visual Web Developer 2010 to make my website.
On my website, i have a "Login" control. Users can create a username and password, which registers them for the site.

What I would like to do, is create a database that contains an entry for each user. Then the user can upload files to the site, and it is saved inside the database under their specific name.
Then in the future, they can access these files (.xml or .txt) anytime.

So my question is:
- how to I get access to the list of users, so I can enter them in my database?
- Is there a way my site can automatically update my database whenever a new user is created on the site?

Thanks for your responses!

 

Hi,
There are entire books written about this sort of thing, for good reason.
Many of us can offer tips but you are going to need to study.
You can find free videos that show how to do this sort of thing on the asp.net site.

That being said, with VWD you can work with your remote SQL Server DB.
You can use it to get a list of tables that are currently in your DB.
Some of those tables list your users and related info.
You can create a new table, based on the user names for example.

One thing about storing files...
It's better to put the files on the server and store a link ot the file.
Unless you have to it's a bad idea to dump files in the DB.
All the best,
Mark