private void bitButton1_Click(object sender, EventArgs e) { DialogResult msg = MessageBox.Show("Wollen Sie wirklich alle Excel-Instanzen beenden.", "Excel", MessageBoxButtons.YesNo, MessageBoxIcon.Exclamation); if (msg == System.Windows.Forms.DialogResult.Yes) { FuncGeneral.KillProgram("EXCEL"); } }
private void rotaBitButton1_Click(object sender, EventArgs e) { FuncGeneral.KillProgram("EXCEL"); ExcelHelper xls = new ExcelHelper(); xls.Workbook_Hinzufuegen(); this.m_SqlHelper.SQLBuilderHinzufuegen("", SQLHelper.SQLBuilder.NoSpace); int i = 0; bool add_select = true; foreach (string ert in this.m_Tablelist) { string table = m_Tablelist[i]; string[] cols = m_ColumnlistOutput[i]; foreach (string col in cols) { if (add_select == true) { add_select = false; this.m_SqlHelper.SQLBuilderHinzufuegen("SELECT TOP 100", SQLHelper.SQLBuilder.DeleteSQL); } string suchen = table + "." + col + ","; this.m_SqlHelper.SQLBuilderHinzufuegen(suchen, SQLHelper.SQLBuilder.NoSpace); } i++; } string sql = ""; string sql_where = ""; string sql_inner_join = ""; sql = this.m_SqlHelper.SQLBuilderHinzufuegen("", SQLHelper.SQLBuilder.NoSpace); sql = FuncGeneral.DeleteRight(sql, 1); this.m_SqlHelper.SQLBuilderHinzufuegen(sql, SQLHelper.SQLBuilder.DeleteSQL); sql = this.m_SqlHelper.SQLBuilderHinzufuegen("", SQLHelper.SQLBuilder.NoSpace); sql_inner_join = this.m_SqlHelperInnerJoin.SQLBuilderHinzufuegen("", SQLHelper.SQLBuilder.NoSpace); sql_where = this.m_SqlHelperWhere.SQLBuilderHinzufuegen("", SQLHelper.SQLBuilder.NoSpace); this.textBox2.Text = sql + sql_inner_join + sql_where; xls.SQL2Excel(this.textBox2.Text, m_ConnectionString); string file_name = "Messwerte" + FuncString.GetOnlyNumeric(FuncString.GetTimestamp()); xls.DateiSpeichern(file_name); xls.ExcelHelperClose(); xls = null; }