private void button1_Click(object sender, EventArgs e) { var sb = new StringBuilder(); var c = getFromCreator(); foreach (var t in _tables) { sb.AppendLine("/***************************************************************/"); sb.AppendLine("/**************** <" + t.TableName + "> *****************/"); sb.AppendLine("/***************************************************************/"); sb.AppendLine("insert into GRINGLOBAL." + t.TableName + " ("); var sbSelect = new StringBuilder(); foreach (var f in t.Fields) { sb.Append(f.Name + ", "); sbSelect.Append(f.Name + ", "); } sb.Length -= 2; sbSelect.Length -= 2; sb.AppendLine(")").AppendLine(" select " + sbSelect.ToString()).AppendLine(" from PROD." + t.TableName + ")"); sb.AppendLine("/"); sb.AppendLine(); sb.AppendLine(); } var form = new frmPreview(); form.txtPreview.Text = sb.ToString(); form.ShowDialog(this); }
private void backgroundProgress(object sender, ProgressChangedEventArgs e) { ProgressEventArgs pea = (ProgressEventArgs)e.UserState; if (pea.Message.StartsWith("SCHEMA:")) { string schema = pea.Message.Substring("SCHEMA:".Length); frmPreview fp = new frmPreview(); fp.txtPreview.Text = schema; fp.txtPreview.SelectionStart = 0; fp.txtPreview.SelectionLength = 0; fp.Show(this); } else { statusText.Text = pea.Message; if (pea.TotalItems > 0) { statusProgress.Value = (int)(((double)pea.ItemOffset / (double)pea.TotalItems) * (double)100); } } //} else if (pea.Message.StartsWith("PERCENT:")) { // } else if (pea.Message.StartsWith("TICK:")){ // updateTimer(); //} else if (pea.Message.StartsWith("Copying data for")) { // lbProgress.Items.Add(pea.Message); // lbProgress.SelectedIndex = lbProgress.Items.Count - 1; // _tableCount++; // lblTotalProgress.Text = "Table " + _tableCount + " of " + this.lvTablesTo.CheckedItems.Count; //} else { // lbProgress.Items.Add(pea.Message); // lbProgress.SelectedIndex = lbProgress.Items.Count - 1; //} }
void backgroundWorker1_ProgressChanged(object sender, ProgressChangedEventArgs e) { ProgressEventArgs pea = (ProgressEventArgs)e.UserState; if (pea.Message.StartsWith("SCHEMA:")) { string schema = pea.Message.Substring("SCHEMA:".Length); frmPreview fp = new frmPreview(); fp.txtPreview.Text = schema; fp.txtPreview.SelectionStart = 0; fp.txtPreview.SelectionLength = 0; fp.ShowDialog(this); } else if (pea.Message.StartsWith("PERCENT:")) { lblStatus.Text = pea.Message.Substring("PERCENT:".Length); //} else if (pea.Message.StartsWith("TICK:")){ // updateTimer(); } else if (pea.Message.StartsWith("Copying data for")) { lbProgress.Items.Add(pea.Message); lbProgress.SelectedIndex = lbProgress.Items.Count - 1; _tableCount++; lblTotalProgress.Text = "Table " + _tableCount + " of " + this.lvTablesTo.CheckedItems.Count; } else { lbProgress.Items.Add(pea.Message); lbProgress.SelectedIndex = lbProgress.Items.Count - 1; } }
private void lbProgress_DoubleClick(object sender, EventArgs e) { if (lbProgress.SelectedItem != null) { frmPreview fp = new frmPreview(); fp.txtPreview.Text = lbProgress.SelectedItem.ToString(); fp.ShowDialog(); } }
private void btnPreviewList_Click(object sender, EventArgs e) { Creator c = Creator.GetInstance(new DataConnectionSpec { ConnectionString = cboConnectionStringFrom.Text, ProviderName = getFromProviderName(), CommandTimeout = COMMAND_TIMEOUT }); lvFromTables.Items.Clear(); List <string> names = c.ListTableNames(txtFromDatabaseOwner.Text); frmPreview fp = new frmPreview(); fp.txtPreview.Text = "DESCRIBE " + String.Join(";\r\nDESCRIBE ", names.ToArray()) + ";"; fp.ShowDialog(this); }