Creating New Databases

Creating New Databases

Old forum URL: forums.lhotka.net/forums/t/7449.aspx


demwa posted on Thursday, August 13, 2009

I have been requested by my client to create a payroll application.The group comprises of multiple companies and the requirement is that each company should have a separate sql db or if they open a new company the application should create a new db.I have created the company object and have put the database creation logic in the dataportal_Create and passing the name of the database to create as a criteria property.I am right in my approach?My problem cames when I want to open a particular company object so that the approriate db connection is open,again I have put the logic in the dataportal_fetch method.My problem is how to retrieve the right connection string from the app.config file.My client also requires that the last four opened companies be visible to the file menu so that they can open any of those compaines by clicking the approriate from the file menu similar to the recently opened documents in MS Word or excel.My thinking for me to achieve this the last four companies recently opened should be stored in the db.How do I achieve this?.Many thanks

Copyright (c) Marimer LLC