private void getTargetColumn()
{
// Get columns comment of target connexion
//TargetConnexion = new Connexion.Connexion("Oracle");
if (TargetConnexion != null)
{
TargetConnexion.Open(TargetConnexion.OracleConnexion.UserId, TargetConnexion.OracleConnexion.Password, TargetConnexion.OracleConnexion.DataSource);
if (TargetConnexion.Cnn.State.ToString() != "Closed")
{
DGVQuery queryTarget = new DGVQuery(TargetDataGridView, TargetConnexion);
queryTarget.Sql = SQL;
toolStripProgressBarQueryTarget.Visible = true;
startTime = DateTime.Now;
BackgroundWorker backgroundWorkerTgt = new BackgroundWorker();
backgroundWorkerTgt.DoWork += new DoWorkEventHandler(backgroundWorkerSrc_DoWork);
backgroundWorkerTgt.ProgressChanged +=
new ProgressChangedEventHandler(backgroundWorkerTgt_ProgressChanged);
backgroundWorkerTgt.RunWorkerCompleted +=
new RunWorkerCompletedEventHandler(backgroundWorkerTgt_RunWorkerCompleted);
backgroundWorkerTgt.WorkerReportsProgress = true;
backgroundWorkerTgt.WorkerSupportsCancellation = true;
if (backgroundWorkerTgt.IsBusy)
backgroundWorkerTgt.CancelAsync();
while (backgroundWorkerTgt.IsBusy) ;
backgroundWorkerTgt.RunWorkerAsync(queryTarget);
}
}
}
private void getSourceColummn()
{
//SourceConnexion = new Connexion.Connexion("Oracle");
SourceConnexion.Open(SourceConnexion.OracleConnexion.UserId, SourceConnexion.OracleConnexion.Password, SourceConnexion.OracleConnexion.DataSource);
// Get columns comment of source connexion
if (SourceConnexion.Cnn.State.ToString() != "Closed")
{
DGVQuery querySource = new DGVQuery(SourceDataGridView, SourceConnexion);
querySource.Sql = SQL;
toolStripProgressBarQuerySource.Visible = true;
startTime = DateTime.Now;
BackgroundWorker backgroundWorkerSrc = new BackgroundWorker();
backgroundWorkerSrc.DoWork += new DoWorkEventHandler(backgroundWorkerSrc_DoWork);
backgroundWorkerSrc.ProgressChanged +=
new ProgressChangedEventHandler(backgroundWorkerSrc_ProgressChanged);
backgroundWorkerSrc.RunWorkerCompleted +=
new RunWorkerCompletedEventHandler(backgroundWorkerSrc_RunWorkerCompleted);
backgroundWorkerSrc.WorkerReportsProgress = true;
backgroundWorkerSrc.WorkerSupportsCancellation = true;
if (backgroundWorkerSrc.IsBusy)
backgroundWorkerSrc.CancelAsync();
while (backgroundWorkerSrc.IsBusy) ;
backgroundWorkerSrc.RunWorkerAsync(querySource);
}
}
