Ejemplo n.º 1
0
        /// <summary>
        /// Load database with password
        /// </summary>
        /// <param name="fileName">Database file name</param>
        /// <param name="password">Database password</param>
        private void LoadDatabase(string fileName, string password)
        {
            Reset();

            try
            {
                if (!File.Exists(fileName))
                {
                    throw new Exception($"{GlobalText.GetValue("FileNotFound")}: '{fileName}'");
                }

                Cursor = Cursors.WaitCursor;

                if (db.Open(fileName, password))
                {
                    Text = string.Concat(formText, " - ", db.FileName);

                    // Fill tree with database name and table names
                    treeDb.BeginUpdate();
                    treeDb.Nodes.Clear();
                    TreeNode main = treeDb.Nodes.Add("Database", Path.GetFileNameWithoutExtension(fileName), 0, 0);
                    foreach (string tableName in db.TableNames)
                    {
                        main.Nodes.Add(tableName, tableName, 1, 1);
                    }
                    main.Expand();
                    treeDb.EndUpdate();
                    treeDb.SelectedNode = treeDb.Nodes[0];
                    settings.AddToRecentFiles(fileName);
                    UpdateRecentFilesMenu();
                }
                else
                {
                    bool badPassword = db.BadPassword;
                    Reset();
                    if (badPassword)
                    {
                        var form = new GetPassForm();
                        if (form.ShowDialog() == DialogResult.OK)
                        {
                            LoadDatabase(fileName, form.edPass.Text.Trim());
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                GlobalText.ShowError("UnableToOpen", ex.Message);
                btnQuery.Enabled = btnExecute.Enabled = btnClear.Enabled = false;
                settings.RemoveFromRecentFiles(fileName);
                UpdateRecentFilesMenu();
            }
            Cursor = Cursors.Default;

            UpdateStatus();
        }
Ejemplo n.º 2
0
 private void LoadDatabase(string fileName, string password)
 {
     tbFileName.Text = fileName;
     tbPassword.Text = password == null ? "" : password;
     if (db.Open(fileName, password))
     {
         cbVersion.Text = db.Version.SqlceVersion;
         openPassword   = password;
         cbUpgradeTo.Items.Clear();
         bool ok = false;
         foreach (Version version in SqlCeDb.AvailableVersions)
         {
             if (ok)
             {
                 cbUpgradeTo.Items.Add(version);
             }
             else if (version == db.Version)
             {
                 ok = true;
             }
         }
         if (cbUpgradeTo.Items.Count == 1)
         {
             cbUpgradeTo.SelectedIndex = 0;
         }
     }
     else
     {
         if (db.BadPassword)
         {
             db.Close();
             GetPassForm form = new GetPassForm();
             if (form.ShowDialog() == DialogResult.OK)
             {
                 LoadDatabase(fileName, form.edPass.Text.Trim());
             }
         }
     }
 }