separate database for separate customers in a single windows c# application

Arun,

follow these steps:

1. Create a database with whatever tables you want to use for each customer or user account. Imagine this as a template and you should not be using this. For example, call it "Master.MDB".

2. You need to have login details and customer details stored in one more database. Call this as "Customer.MDB".

3. So, your user account table should have following columns

UserID        ShortName         LongName
=====        ========        ========
1                 ADMRM                A.D.Modern Rice Mill
2                 CTA                     Chandru Trading Account

Make sure that ShortName is unique.

4. Whenever you create a new user, create a new folder with user id. For example user1 is getting created, then create a folder with name "User1".


Then copy the "Master.DB" file to the folder path C:\User1 as below with database name as shortname.mdb:

System.IO.File.Copy(@"C:\MDB\FPNWIND.MDB", @"C:\User1\ADRM.MDB");

5. Whenever a user logins into the system, make sure that you connect to the database using datasource pointing to the location with the format

"C:\" + userid + selected account shortname + ".mdb" and use this mdb file for storing the whatever you are planning.

This makes sure that you create a new database for each user and for each account and you should be able to use it too.

There are some examples given if you google regarding create mdb file using COM components and others which you do not need to follow. 

Let me know if you have any questions.


 

sir, i have crate 2 or more user account in one application login page( see my uploaded pictures,)my data base structure is same but database is automatically create indidual user accounts

ex:

my data base name is 1.mdb
1st user data base is rec_1.mdb        
2nd user data base is rec_2.mdb
etc..


please help me

Is your requirement is to create one database per user account? Or you want to do this only for one user?