C#

public partial class ClientLogin : Window
{
    public Client client = new Client();

    OleDbConnection conn = new OleDbConnection();
    OleDbDataAdapter dtAdapter = new OleDbDataAdapter();
    OleDbCommand command = new OleDbCommand();
    OleDbDataReader dataReader;// = new OleDbDataReader();

    //public TextBox txtIPaddress = new System.Windows.Controls.TextBox();
    //public TextBox txtPortNumber = new System.Windows.Controls.TextBox();

    public ClientLogin()
    {
        InitializeComponent();
        conn.ConnectionString = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\AP_AE\Desktop\DTPOS_ClientServer\DataBase\DtposMenu.accdb";
        //command.CommandText.ToString();
    }

    public void infoChecker(Client formOne)
    {
        this.client = formOne;
        this.Show();
    }

    // IsNumeric Function
    static bool IsNumeric(object Expression)
    {
        // Variable to collect the Return value of the TryParse method.
        bool isNum;

        // Define variable to collect out parameter of the TryParse method. If the conversion fails, the out parameter is zero.
        double retNum;

        // The TryParse method converts a string in a specified style and culture-specific format to its double-precision floating point number equivalent.
        // The TryParse method does not generate an exception if the conversion fails. If the conversion passes, True is returned. If it does not, False is returned.
        isNum = Double.TryParse(Convert.ToString(Expression), System.Globalization.NumberStyles.Any, System.Globalization.NumberFormatInfo.InvariantInfo, out retNum);
        return isNum;
    }

    private void btnLogin_Click(object sender, RoutedEventArgs e)
    {
        // Using Try-Catch-Finally block structure
        try
        {
            if (IsNumeric(txtUserId.Text) & IsNumeric(txtPassword.Text))
            {
                // Open database connection
                conn.Open();
                // Set SQL select command to check User_ID and User_Password
                dtAdapter.SelectCommand.CommandText = "SELECT * FROM Users WHERE ID = '" + txtUserId.Text + "' AND Password = '" + txtPassword.Text + "'";
                dataReader = dtAdapter.SelectCommand.ExecuteReader();
                dataReader.Read();

                MessageBox.Show(" - You Have Loged In As: - " + dataReader["Access Level"].ToString() + "\n" + "\n" + " - Welcome " + dataReader["Name"].ToString() + "\n" + "\n" + " - To DTPOS - Point Of Sale System ", "Login Successful", MessageBoxButton.OK, MessageBoxImage.Information);
                UserLoginModule.UserAccessLevel = dataReader["Access Level"].ToString();
                UserLoginModule.UserFullName = dataReader["Name"].ToString();

                //ToDo: Error processing original source shown below
                //--^--- Unexpected pre-processor directive
                this.client.startServer(txtIpAddress.Text.ToString().Trim(), Convert.ToInt32(txtPortNumber.Text.ToString().Trim()), Convert.ToInt32(txtUserId.Text.ToString().Trim()), Convert.ToInt32(txtPassword.Text.ToString().Trim()));
                // Always call Close when done reading.
                if ((dataReader != null))
                {
                    dataReader.Close();
                }
                this.Close();

            }
            else
            {
                MessageBox.Show("You must enter data in order to proceed further. Please try again...", "Error: Non Data Entry", MessageBoxButton.OK, MessageBoxImage.Information);
                txtUserId.Focus();
            }
            // Display error if unable to open database
        }
        catch (System.Data.OleDb.OleDbException exception)
        {
            MessageBox.Show(exception.StackTrace);
            MessageBox.Show(exception.ToString(), "Unable to open database!");
            // Display message box when invalid operation
        }
        catch (InvalidOperationException invalidOperationException)
        {
            MessageBox.Show(invalidOperationException.Message, "An Invalid Operation Exception");
        }
        finally
        {
            // Close database connection when done with it
            if ((conn.State == ConnectionState.Open))
            {
                conn.Close();
            }
        }
        this.Close();
    }

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