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