private void btnConnect_Click(object sender, EventArgs e) { grpDatabase.Enabled = false; try { if (txtSQLServerName.Text.Length == 0) { return; } if (!chkUseWindowsAuthentication.Checked && txtUserName.Text.Length == 0 && txtPassword.Text.Length == 0) { return; } smoHelper = new Classes.SMOHelper(txtSQLServerName.Text.Trim(), txtUserName.Text.Trim(), txtPassword.Text.Trim(), chkUseWindowsAuthentication.Checked); smoHelper.Connect(); if (smoHelper.Server != null) { smoHelper.BackupPercentCompleteChanging += Backup_PercentCompleteChanging; smoHelper.BackupComplete += Backup_Complete; smoHelper.RestorePercentCompleteChanging += Restore_PercentCompleteChanging; smoHelper.RestoreComplete += Restore_Complete; cboDatabase.DataSource = smoHelper.GetDatabaseNameList(); cboDatabase.Focus(); grpDatabase.Enabled = true; grpActions.Enabled = true; } else { MessageBox.Show("Connect MSSQL Server Failed!"); } } catch (Exception ex) { MessageBox.Show("Connect MSSQL Server Failed! See errors in *.Log"); Log.Debug(ex.Message, ex); } finally { GC.Collect(); } }
private void RefreshCboDatabase(string databaseName) { try { smoHelper = new Classes.SMOHelper(txtSQLServerName.Text.Trim(), txtUserName.Text.Trim(), txtPassword.Text.Trim(), chkUseWindowsAuthentication.Checked); smoHelper.Connect(); if (smoHelper.Server != null) { smoHelper.BackupPercentCompleteChanging += Backup_PercentCompleteChanging; smoHelper.BackupComplete += Backup_Complete; smoHelper.RestorePercentCompleteChanging += Restore_PercentCompleteChanging; smoHelper.RestoreComplete += Restore_Complete; cboDatabase.DataSource = smoHelper.GetDatabaseNameList(); cboDatabase.SelectedItem = databaseName; } else { MessageBox.Show("Refresh MSSQL Server Failed!"); } } catch (Exception ex) { MessageBox.Show("Refresh MSSQL Server Failed! See errors in *.Log"); Log.Debug(ex.Message, ex); } finally { GC.Collect(); } }