コード例 #1
0
        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;
            }
        }
コード例 #2
0
        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;
            }
        }