C#

dtAdapter.SelectCommand = command

using System;
using System.IO;
using System.Windows.Forms;
using SoundForge;

public class EntryPoint {
public string Begin(IScriptableApp app) {

   string[] outputs = new string[] {
      ".wav|Default Template",
   };

   string szDir = GETARG("Dir", @"c:\");

   ISfFileHost file = app.CurrentFile;
   if (null == file)
      return "No files are open. Script canceled.";

   string szBase = file.Window.Title;

   DPF("Start Rendering... ");
   foreach (string output in outputs)
   {

      string[] fmt = output.Split(new char[]{'|',';'},2);

// find the renderer

      ISfRenderer rend = null;
      if (fmt[0].StartsWith("."))
          rend = app.FindRenderer(null, fmt[0]);
      else
          rend = app.FindRenderer(fmt[0], null);
      if (null == rend)
      {
         DPF("renderer for type {0} not found - skipping to next", fmt[0]);
         continue;
      }

      // determine if the preset is a string or an integer

      object vPreset = fmt[1];

      string szName = String.Format("{0}", szBase, fmt[1], rend.Extension);
      DPF("rendering {0}", szName);
      string szFilename = Path.Combine(szDir, szName);
      DPF(" ~ {0}", szFilename);

      // now, render the file
      //
      file.RenderAs(szFilename, rend.Guid, vPreset, null, RenderOptions.RenderOnly);
      SfStatus result = file.WaitForDoneOrCancel();
      if (result != SfStatus.Success)
         continue;

file.Close(CloseOptions.DiscardChanges);

   } // foreach

   return null;

}

public void FromSoundForge(IScriptableApp app) {
   ForgeApp = app; //execution begins here
   app.SetStatusText(String.Format("Script '{0}' is running.", Script.Name));
   string msg = Begin(app);
   app.SetStatusText(msg != null ? msg : String.Format("Script '{0}' is done.", Script.Name));
}
public static IScriptableApp ForgeApp = null;
public static void DPF(string sz) { ForgeApp.OutputText(sz); }
public static void DPF(string fmt, object o) { ForgeApp.OutputText(String.Format(fmt,o)); }
public static void DPF(string fmt, object o, object o2) { ForgeApp.OutputText(String.Format(fmt,o,o2)); }
public static void DPF(string fmt, object o, object o2, object o3) { ForgeApp.OutputText(String.Format(fmt,o,o2,o3)); }
public static string GETARG(string k, string d) { string val = Script.Args.ValueOf(k); if (val == null || val.Length == 0) val = d; return val; }
public static int    GETARG(string k, int d) { string s = Script.Args.ValueOf(k); if (s == null || s.Length == 0) return d; else return Script.Args.AsInt(k); }
public static bool   GETARG(string k, bool d) { string s = Script.Args.ValueOf(k); if (s == null || s.Length == 0) return d; else return Script.Args.AsBool(k); }
} //EntryPoint

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();
}