private void btnGetAllDataBases_Click(object sender, EventArgs e)
{
if (cmbSqlServers.Items.Count > 0 &&
txtPassword.Text.Trim().CompareTo(string.Empty) != 0 &&
txtUserName.Text.Trim().CompareTo(string.Empty) != 0)
{
ticker.Start();
btnGetAllDataBases.Enabled = false;
this.Cursor = Cursors.WaitCursor;
cmbAllDataBases.Items.Clear();
sqlInfo.SQLServer = cmbSqlServers.Text.Trim();
sqlInfo.Username = txtUserName.Text.Trim();
sqlInfo.Password = txtPassword.Text.Trim();
MessageBox.Show("You may get the list sql servers if user name and password are not correct.", "Information",
MessageBoxButtons.OK, MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1, 0, false);
intlDelg = new InternalDelegate(sqlInfo.EnumerateSQLServersDatabases);
called = CallFor.SqlDataBases;
intlDelg.BeginInvoke(new AsyncCallback(CallBackMethod), intlDelg);
}
else
{
MessageBox.Show("No sql servers loaded or user name or password empty...", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, 0, false);
}
}
private void btnLoadSqlServers_Click(object sender, EventArgs e)
{
ticker.Start();
btnLoadSqlServers.Enabled = false;
this.Cursor = Cursors.WaitCursor;
cmbSqlServers.Items.Clear();
cmbSqlServers.Items.Add(MyModules.ServerName);
called = CallFor.SqlServerList;
intlDelg.BeginInvoke(new AsyncCallback(CallBackMethod), intlDelg);
cmbSqlServers.Text = MyModules.ServerName;
}
private void btnGetAllTables_Click(object sender, EventArgs e)
{
if (cmbAllDataBases.Text.Trim().CompareTo(string.Empty) != 0)
{
btnGetAllTables.Enabled = false;
this.Cursor = Cursors.WaitCursor;
StringBuilder connStr = new StringBuilder();
connStr.Append("Database=");
connStr.Append(cmbAllDataBases.Text);
connStr.Append(";Server=");
connStr.Append(cmbSqlServers.Text);
connStr.Append(";User="******";Password="******";Enlist=false; Asynchronous Processing=true");
connectionString = connStr.ToString();
sqlQuery = getTablesFromDataBase;
SetDataObjects();
try
{
ticker.Start();
connection.Open();
command.BeginExecuteReader(new AsyncCallback(CallBackMethod),
command, CommandBehavior.CloseConnection);
called = CallFor.SqlTables;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
ticker.Stop();
}
finally
{
btnGetAllTables.Enabled = true;
this.Cursor = Cursors.Default;
}
}
else
{
MessageBox.Show("Please select database first.",
"No database", MessageBoxButtons.OK, MessageBoxIcon.Warning,
MessageBoxDefaultButton.Button1, 0, false);
}
}
private void btnLoadSqlServers_Click(object sender, EventArgs e)
{
ticker.Start();
btnLoadSqlServers.Enabled = false;
this.Cursor = Cursors.WaitCursor;
cmbSqlServers.Items.Clear();
called = CallFor.SqlServerList;
intlDelg.BeginInvoke(new AsyncCallback(CallBackMethod), intlDelg);
}
private void btnGetAllTables_Click(object sender, EventArgs e)
{
if (cmbAllDataBases.Text.Trim().CompareTo(string.Empty) != 0)
{
btnGetAllTables.Enabled = false;
this.Cursor = Cursors.WaitCursor;
StringBuilder connStr = new StringBuilder();
connStr.Append("Database=");
connStr.Append(cmbAllDataBases.Text);
connStr.Append(";Server=");
connStr.Append(cmbSqlServers.Text);
connStr.Append(";User="******";Password="******";Enlist=false; Asynchronous Processing=true");
connectionString = connStr.ToString();
sqlQuery = getTablesFromDataBase;
SetDataObjects();
try
{
ticker.Start();
connection.Open();
command.BeginExecuteReader(new AsyncCallback(CallBackMethod),
command, CommandBehavior.CloseConnection);
called = CallFor.SqlTables;
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
ticker.Stop();
}
finally
{
btnGetAllTables.Enabled = true;
this.Cursor = Cursors.Default;
}
}
else
{
MessageBox.Show("Please select database first.",
"No database", MessageBoxButtons.OK, MessageBoxIcon.Warning,
MessageBoxDefaultButton.Button1, 0, false);
}
}
private void btnGetAllDataBases_Click(object sender, EventArgs e)
{
if (cmbSqlServers.Items.Count > 0 &&
txtPassword.Text.Trim().CompareTo(string.Empty) != 0 &&
txtUserName.Text.Trim().CompareTo(string.Empty) != 0)
{
ticker.Start();
btnGetAllDataBases.Enabled = false;
this.Cursor = Cursors.WaitCursor;
cmbAllDataBases.Items.Clear();
sqlInfo.SQLServer = cmbSqlServers.Text.Trim();
sqlInfo.Username = txtUserName.Text.Trim();
sqlInfo.Password = txtPassword.Text.Trim();
MessageBox.Show("You may get the list sql servers if user name and password are not correct.", "Information",
MessageBoxButtons.OK, MessageBoxIcon.Information,
MessageBoxDefaultButton.Button1, 0, false);
intlDelg = new InternalDelegate(sqlInfo.EnumerateSQLServersDatabases);
called = CallFor.SqlDataBases;
intlDelg.BeginInvoke(new AsyncCallback(CallBackMethod), intlDelg);
}
else
{
MessageBox.Show("No sql servers loaded or user name or password empty...", "Error", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, 0, false);
}
}
