C#

public void connectToDatabase()
    {
    DataBaseManager.conn = new OleDbConnection(this.dbConnPath);
    if (DataBaseManager.conn == null)
        {
        MessageBox.Show("Can't connect to database", "WorkManager", MessageBoxButtons.OK, MessageBoxIcon.Information);
        }
    else
        {
        String state = DataBaseManager.conn.State.ToString();
        using (File.Open(Environment.CurrentDirectory + "\\" + userName + ".accdb", FileMode.Open))
            {
            if (state.Equals("Closed"))
                {
                DataBaseManager.conn.Open();
                }
            }
        }
    }

DataBaseManager.conn.Open();

using (File.Open(Environment.CurrentDirectory + "\\" + userName + ".accdb", FileMode.Open))

System.Reflection.Assembly objAssembly = System.Reflection.Assembly.GetExecutingAssembly();
using (Stream blankDBData = objAssembly.GetManifestResourceStream("MyBlankDB.accdb"))
    {
    byte[] data = new Byte[blankDBData.Length];
    blankDBData.Read(data, 0, (int) blankDBData.Length);
    blankDBData.Close();
    using (FileStream newDBFile = new FileStream(pathToWhereIWantToPutTheDatabase, FileMode.Create))
        {
        newDBFile.Write(data, 0, (int) blankDBData.Length);
        newDBFile.Close();
        }
    }

Marat Beiner wrote:

I wont to create for every user his private data base

Marat Beiner wrote:

I create an accdb file for him, connect to this data base and create tables

I are Troll

// delete file if it exists
if (File.Exists(this.txtDBPath.Text + this.txtDbName.Text + ".accdb"))
{
    File.Delete(this.txtDBPath.Text + this.txtDbName.Text + ".accdb");
}

Catalog cat = new Catalog();
try
{
    string creationString = "Provider=Microsoft.ACE.OLEDB.12.0;" +
        " Data Source=" + this.txtDBPath.Text + this.txtDbName.Text + ".accdb";
    cat.Create(creationString);

    MessageBox.Show("Database Created Successfully");
}
catch (Exception ex)
{
    // Hopefully
    MessageBox.Show("Oh deary, deary me." + Environment.NewLine + ex.ToString(), "Oooops");
    return;
}

// Make sure that 'cat' gets disposed
cat = null;

// Create an OleDbConnectionString to use from now on.
OleDbConnectionStringBuilder connBuilder = new OleDbConnectionStringBuilder();
connBuilder.DataSource = this.txtDBPath.Text + this.txtDbName.Text + ".accdb";
connBuilder.Provider = "Microsoft.ACE.OLEDB.12.0";
OleDbConnection tablesConn = new OleDbConnection(connBuilder.ConnectionString);
// Create the Tables that you want
this.CreateTables(tablesConn);

private void CreateTables(OleDbConnection conn)
{
    string tableSql = @"CREATE TABLE FoodTable(FoodID SHORT NOT NULL , FoodName VARCHAR(30) NOT NULL , FoodType VARCHAR(15) NOT NULL , FoodPrice CURRENCY NOT NULL )";
    OleDbCommand tableCommand = new OleDbCommand(tableSql, conn);
    conn.Open();
    tableCommand.ExecuteNonQuery();
    conn.Close();
}

delegate string MyMethodDelegate();
static void MyMethod()
{
   MyMethodDelegate readALineFromUser = new MyMethodDelegate(Console.ReadLine);
   Console.WriteLine("Enter your name:");
   string inp = readALineFromUser();
   Console.WriteLine("Your name is\"{0}\". ", inp);
}

delegate string MyMethodDelegate();
static void MyMethod()
{
   MyMethodDelegate readALineFromUser = new MyMethodDelegate(MyBatchFileReadLine);
   Console.WriteLine("Enter your name:");
   string inp = readALineFromUser();
   Console.WriteLine("Your name is\"{0}\". ", inp);
}