private void settingsControl1_ServerChanged(object sender, string serverName, string username, string password, AuthenticationType authType)
{
Connection.ConnectionData oldConnData = new Connection.ConnectionData();
this.connData.Fill(oldConnData);
this.Cursor = Cursors.WaitCursor;
this.connData.SQLServerName = serverName;
if (!string.IsNullOrWhiteSpace(username) && (!string.IsNullOrWhiteSpace(password)))
{
this.connData.UserId = username;
this.connData.Password = password;
}
this.connData.AuthenticationType = authType;
this.connData.ScriptTimeout = 5;
try
{
dbList = SqlSync.DbInformation.InfoHelper.GetDatabaseList(this.connData);
ddDatabases.Items.Clear();
ddDatabases.Items.AddRange(dbList.ToArray());
// bgWorker.RunWorkerAsync();
}
catch
{
MessageBox.Show("Error retrieving database list. Is the server running?", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
this.connData = oldConnData;
this.settingsControl1.Server = oldConnData.SQLServerName;
}
this.Cursor = Cursors.Default;
}
public RebuildForm(Connection.ConnectionData connData, DatabaseList databaseList)
{
this.dbList = databaseList;
this.connData = connData;
InitializeComponent();
ddDatabases.Items.AddRange(databaseList.ToArray());
}
private void changeSqlServerConnectionToolStripMenuItem_Click(object sender, EventArgs e)
{
ConnectionForm frmConnect = new ConnectionForm("Build File Reconstructor");
DialogResult result = frmConnect.ShowDialog();
if (result == DialogResult.OK)
{
this.connData = frmConnect.SqlConnection;
this.settingsControl1.Server = this.connData.SQLServerName;
this.dbList = frmConnect.DatabaseList;
ddDatabases.Items.Clear();
ddDatabases.Items.AddRange(dbList.ToArray());
//bgWorker.RunWorkerAsync();
}
}