private void CreateDatabaseHandler(object sender, EventArgs e) { var connectionInfo = SettingsToConnectionInfo(Properties.Settings.Default); using (DatabaseLoginDialog dialog = new DatabaseLoginDialog()) { dialog.Text = "Create Database"; dialog.StartPosition = FormStartPosition.CenterScreen; dialog.ConnectionInfo = connectionInfo; dialog.ValidatingLogin += new EventHandler<ValidatingLoginEventArgs>(dialog_ValidatingCreateDatabaseLogin); createDatabaseConnection = null; try { if (dialog.ShowDialog() != DialogResult.OK) { return; } //using (var cmd = createDatabaseConnection.CreateCommand()) //{ // cmd.CommandText = "CREATE DATABASE [@database]"; // cmd.Parameters.Add(new SqlParameter("@database", databaseName)); // messageContext = "There was an error creating the database."; // cmd.ExecuteNonQuery(); //} } finally { if (createDatabaseConnection != null) { createDatabaseConnection.Dispose(); createDatabaseConnection = null; } } //??UpdateDatabase("Creating database..."); //??notifyIcon.Icon = Properties.Resources.Clock; } }
private void ConnectHandler(object sender, EventArgs e) { var connectionInfo = SettingsToConnectionInfo(Properties.Settings.Default); using (DatabaseLoginDialog dialog = new DatabaseLoginDialog()) { dialog.StartPosition = FormStartPosition.CenterScreen; dialog.ConnectionInfo = connectionInfo; dialog.ValidatingLogin += new EventHandler<ValidatingLoginEventArgs>(dialog_ValidatingLogin); if (dialog.ShowDialog() != DialogResult.OK) { return; } //!!UpdateDatabase("Updating database..."); notifyIcon.Icon = Properties.Resources.Clock; } }