How to store data about my customers? How to link & update 2 tables?

[may1hem]

I am asking my customers to create a new account for themselves, and this works fine using the ASP.net CreateNewUser wizard control. But now I want to store various extra information about my customers, such as details of which products they buy. How can I do this?

I'm familiar with how to do this in Microsoft Access, but now my Web space uses SQL Server 2000 and I'm using Visual Studio 2005 and I want to learn how to use these new tools.

Taking the simple scenario, one of my customers logs into my site, then I want them to choose a product or service that they're interested in. From my Access experience, I know that I need to store a list of my products & services in a separate table and use a third linking table with extra information about each individual purchase such as quantity and date of puchase etc.

I can create the tables easily in SQL Server but I don't know how to create the form and then how to store the data back into the tables, including the currently logged-on user's ID.

How can I do this?

Thanks,
May

 

[Ecreations]

Just use Personalization in asp.net with SQL 2000

Check this link out

http://weblogs.asp.net/scottgu/archive/2005/08/25/423703.aspx

It's an easy process, just use aspnet_regsql.exe and it will start the wizard to create the tables in the sql2000 server.

Good luck

 

[Ecreations]

Sorry to answer your linking and updating question, the idea is of creating the tables in SQL is like creating them in access "If you can say that".
You need unique keys to establish a relationship between the tables in sql just like you do in access.
there are a lot of documentations of this subject, just google it and I am sure you will find all you need.


Good luck

 

[may1hem]

Thanks for your advice, I'm working through this now.

May