Hello I am about to build a CUSTOMER MANAGEMENT SYSTEM as I call it.
I would greately a appreciate your help.
The plan is to create a web application where a person (business owner or self employed person) would log in and would be able to create, edit or delete customers, create reports, print reports and email invoices. No problem, I know how to do this.
My question is: What is the best way to manage each account.
A).- If to use one database for all users, or
B).- Assign to each one a database
I am totally ignorant about how other systems do it.
I would like to assign each a database, but how to supply a connection string to some of the SqlDataSource objects which would be hard-coded in to some of pages to be used to populate GridViews.
Please help me out here. Tell me how to do this or point me in the right direction.
Thanks.