private void linkLabel4_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { frmInformation f = new frmInformation(DBManager.Properties.Resources.PHPpagesPORTALprocedureDELETE_callexample); f.ShowDialog(); f.Dispose(); }
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { MessageBox.Show("mysqli script is broken, due new method of exchange (server -> client), use v2.3.9 instead."); frmInformation i = new frmInformation(DBManager.Properties.Resources.tunnelPHP); i.ShowDialog(); }
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { if (chkMYSQLtunnelBATCH.Checked) { frmInformation i = new frmInformation(DBManager.Properties.Resources.tunnelPHPtransBATCH); i.ShowDialog(); } else { frmInformation i = new frmInformation(DBManager.Properties.Resources.tunnelPHPtrans); i.ShowDialog(); } }
private void btnCopyRows_Click(object sender, EventArgs e) { if (cmbFROM.Text.Length == 0 || cmbTO.Text.Length == 0 || DG.Rows.Count == 0) { return; } //if ((General.dbTypes)General.DB. == General.dbTypes.Access) // if (General.Connections[cmbSourceServer.SelectedIndex].filename.ToLower().EndsWith("xlsx")) // if (General.Mes("WARNING! XLSX import is broken, I couldnt find a solution, shows that rows imported but in the end there is no rows in sheet!\r\n\r\nContinue?",MessageBoxIcon.Exclamation,MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.No) // return; DataTable sourceDT; if (cmbFROM.SelectedIndex == 0) { sourceDT = sourceDB.getDatatable(txtCustomSQL.Text); } else { //for xls if (sourceDB is ADOnet) { sourceDT = sourceDB.getDatatable("select * from [" + cmbFROM.Text + "]"); } else { sourceDT = sourceDB.getDatatable("select * from " + cmbFROM.Text); } } if (sourceDT != null && sourceDT.Rows.Count == 0) { MessageBox.Show("Source has no rows!", General.apTitle, MessageBoxButtons.OK, MessageBoxIcon.Information); sourceDT.Dispose(); return; } List <string> sourceFields = new List <string>(); List <string> destFields = new List <string>(); string INSsql = ""; string INSfields = ""; string INSvalues = ""; string mySQLtunnel_Q_VARS = ""; string mySQLtunnel_Q_S_VARS = ""; for (int i = DG.Rows.Count - 1; i >= 0; i--) { if (DG.Rows[i].Cells[1].Value == null || DG.Rows[i].Cells[1].Value.ToString().Length == 0) { DG.Rows.RemoveAt(i); } else { //INSfields += "[" + DG.Rows[i].Cells[1].Value.ToString() + "],"; if (General.DB is MySQLTunnel) { INSfields += DG.Rows[i].Cells[1].Value.ToString() + ","; INSvalues += " ?,"; } else { INSfields += DG.Rows[i].Cells[1].Value.ToString() + ","; INSvalues += "@" + DG.Rows[i].Cells[1].Value.ToString() + ","; } sourceFields.Add(DG.Rows[i].Cells[0].Value.ToString()); destFields.Add(DG.Rows[i].Cells[1].Value.ToString()); } } if (INSfields.Length == 0) { MessageBox.Show("Nothing to do!", General.apTitle, MessageBoxButtons.OK, MessageBoxIcon.Information); return; } INSfields = INSfields.Substring(0, INSfields.Length - 1); INSvalues = INSvalues.Substring(0, INSvalues.Length - 1); INSsql = "INSERT INTO " + cmbTO.Text + "(" + INSfields + ") VALUES (" + INSvalues + ")"; General.dbTypes destDBtype = General.dbTypes.Access; if (General.DB is SQLServer) { destDBtype = General.dbTypes.SQLSERVER; } else if (General.DB is MySQL) { destDBtype = General.dbTypes.MySQL; } else if (General.DB is MySQLTunnel) { destDBtype = General.dbTypes.MySQLtunnel; } else if (General.DB is SQLite) { destDBtype = General.dbTypes.SQLite; } else if (General.DB is ADOnet) { INSsql = "INSERT INTO [" + cmbTO.Text + "](" + INSfields + ") VALUES (" + INSvalues + ")"; destDBtype = General.dbTypes.Access; } object result = null; if (destDBtype != General.dbTypes.MySQLtunnel) { result = WaitWindow.Show(CopyRows, "Init...", INSsql, sourceDT, sourceFields, destFields, cmbTO.Text, destDBtype); } else { if (chkMYSQLtunnelBATCH.Checked) { result = WaitWindow.Show(mySQLtunnel_CopyRowsBATCH, "Init...", INSsql, sourceDT, sourceFields, destFields, cmbTO.Text, destDBtype); } else { result = WaitWindow.Show(mySQLtunnel_CopyRows, "Init...", INSsql, sourceDT, sourceFields, destFields, cmbTO.Text, destDBtype); } } if (sourceDT != null) { sourceDT.Dispose(); } if (result == null) { MessageBox.Show("Aborted by user!", General.apTitle, MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (result.ToString() == "ok") { sourceDB.Disconnect(); this.DialogResult = System.Windows.Forms.DialogResult.Yes; } else { if (destDBtype != General.dbTypes.MySQLtunnel) { MessageBox.Show(result.ToString(), General.apTitle, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } else { frmInformation i = new frmInformation(result.ToString()); i.ShowDialog(); } } if (cmbFROM.Text.Length == 0 || cmbTO.Text.Length == 0 || DG.Rows.Count == 0) { return; } }
private void linkLabel2_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { frmInformation i = new frmInformation(DBManager.Properties.Resources.tunnelPHP_PDO); i.ShowDialog(); }