private void btnReadIdocFromDb_Click(object sender, EventArgs e) { String dbName = ConfigFileTool.SAPGlobalSettings.GetDefaultDbConnection(); dt = new DataTable(); SAPINTDB.netlib7 dbhelper = new SAPINTDB.netlib7(dbName); String sqlstr = String.Format("select * from EDIDC where docnum like '{0}'", this.txtIdocNumber.Text.Trim()); dbhelper.DataTableFill(dt, sqlstr); this.dataGridView1.DataSource = null; this.dataGridView1.DataSource = dt; var dt2 = new DataTable(); sqlstr = String.Format("select * from EDID4 where docnum like '{0}'", this.txtIdocNumber.Text.Trim()); dbhelper.DataTableFill(dt2, sqlstr); this.dataGridView2.DataSource = null; this.dataGridView2.DataSource = dt2; var dt3 = new DataTable(); sqlstr = String.Format("select * from EDIDS where docnum like '{0}'", this.txtIdocNumber.Text.Trim()); dbhelper.DataTableFill(dt3, sqlstr); this.dataGridView3.DataSource = null; this.dataGridView3.DataSource = dt3; }
private void btnOpenTemplateTable_Click(object sender, EventArgs e) { String dbName = ConfigFileTool.SAPGlobalSettings.GetTemplateDb(); dt = new DataTable(); SAPINTDB.netlib7 dbhelper = new SAPINTDB.netlib7(dbName); dbhelper.LogEvents = true; dbhelper.DataTableFill(dt, "Select * from codeTemplate"); this.userDataGridView.DataSource = null; this.userDataGridView.DataSource = dt; }
private void btnReadIdocFromDb_Click(object sender, EventArgs e) { String dbName = ConfigFileTool.SAPGlobalSettings.GetDefaultDbConnection(); dt = new DataTable(); SAPINTDB.netlib7 dbhelper = new SAPINTDB.netlib7(dbName); String sqlstr = String.Format("select * from EDIDC where docnum like '{0}'", this.txtIdocNumber.Text.Trim()); dbhelper.DataTableFill(dt, sqlstr); this.dataGridView1.DataSource = null; this.dataGridView1.DataSource = dt; var dt2 = new DataTable(); sqlstr = String.Format("select * from EDID4 where docnum like '{0}'", this.txtIdocNumber.Text.Trim()); dbhelper.DataTableFill(dt2, sqlstr); this.dataGridView2.DataSource = null; this.dataGridView2.DataSource = dt2; var dt3 = new DataTable(); sqlstr = String.Format("select * from EDIDS where docnum like '{0}'", this.txtIdocNumber.Text.Trim()); dbhelper.DataTableFill(dt3, sqlstr); this.dataGridView3.DataSource = null; this.dataGridView3.DataSource = dt3; }
private void btnExcute_Click(object sender, EventArgs e) { try { String dbName = ConfigFileTool.SAPGlobalSettings.GetDefaultDbConnection(); dt = new DataTable(); SAPINTDB.netlib7 dbhelper = new SAPINTDB.netlib7(dbName); dbhelper.DataTableFill(dt, this.syntaxBoxControl1.Document.Text); this.dataGridView1.DataSource = null; this.dataGridView1.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnExcute_Click(object sender, EventArgs e) { try { String dbName = ConfigFileTool.SAPGlobalSettings.GetDefaultDbConnection(); dt = new DataTable(); SAPINTDB.netlib7 dbhelper = new SAPINTDB.netlib7(dbName); dbhelper.DataTableFill(dt, this.syntaxBoxControl1.Document.Text); this.dataGridView1.DataSource = null; this.dataGridView1.DataSource = dt; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnOpenTemplateTable_Click(object sender, EventArgs e) { String dbName = ConfigFileTool.SAPGlobalSettings.GetTemplateDb(); dt = new DataTable(); SAPINTDB.netlib7 dbhelper = new SAPINTDB.netlib7(dbName); dbhelper.LogEvents = true; dbhelper.DataTableFill(dt, "Select * from codeTemplate"); this.userDataGridView.DataSource = null; this.userDataGridView.DataSource = dt; }