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