Chapter 15: Login Controls & Database Connections

Filespit · October 26th, 2011, 11:00 AM

Hi, this is related to mainly Chapter 15, but parts from Chapter 11-14 as well.

I am building a website similar to the one that is built in this book. I have a database in which I have several tables. On my website I can display data from the database, update and delete. Then I also have a login control, as I want users to be able to login and for example comment on news updates.

In Chapter 15, Page 543 and forward, the WSAT is used to manage accounts and such. This works perfectly for me, but now comes the "tricky" part. The WSAT automatically creates a new database with all required tables etc, but I want to use and administrate my own database. I want the users to be registrered in my database, not in the ASPNETDB database that is created. How do I do that? I have tried clicking "Exclude from project" on the ASPNETDB database, and my ConnectionString in my web.config file has my own database in it, so I don't understand what I am doing wrong.

Help would be much appreciated.

Imar · October 29th, 2011, 09:46 AM

Hi there,

Take a look at Appendix B, page 702 and further to learn how to use a tool called aspnet_regsql to merge the two databases.

Cheers,

Imar

Filespit · October 30th, 2011, 01:00 PM

Hi Imar,

I've looked into this but the client can't find my database. I suppose I havn't specified the correct location, how do I do that?
EDIT: The book says I should write [local]/SQLExpress, but my database is not located there, but in a specific folder. How do I specify that?

Cheers

Peter

Imar · October 30th, 2011, 01:02 PM

You can create a connection when using aspnet_regsql in wizard module (if you run it by double-clicking it in Windows). Alternatively, when you run the tool from the command line you can supply connection details. Type aspnet_regsql /? at the command prompt for more details.

Cheers,

Imar