private void Form3_Load(object sender, EventArgs e) { this.Text = string.Format(Tag.ToString(), table); string s_sql = AppFunc.GetSql(conStr, 3, table); dataGridView1.DataSource = AppFunc.GetData(conStr, s_sql); }
private void toolStripButton2_Click(object sender, EventArgs e) { if (conStr == null) { toolStripButton1_Click(null, null); } if (conStr == null) { return; } richTextBox2.Text = ""; string s_sql = richTextBox1.SelectedText.Trim(); if (string.IsNullOrEmpty(s_sql)) { s_sql = richTextBox1.Text; } if (s_sql.ToLower().StartsWith("select")) { dataGridView1.DataSource = null; try { dataGridView1.DataSource = AppFunc.GetData(conStr, s_sql); tabControl1.SelectedIndex = 0; } catch (Exception ex) { richTextBox2.Text = ex.ToString(); tabControl1.SelectedIndex = 1; } } else { dataGridView1.DataSource = null; try { int ret = AppFunc.ExecuteNonQuery(conStr, s_sql); richTextBox2.Text = string.Format("执行语句成功,影响{0}行", ret); tabControl1.SelectedIndex = 1; } catch (Exception ex) { richTextBox2.Text = ex.ToString(); tabControl1.SelectedIndex = 1; } } }
void LoadDb() { treeView1.Nodes.Clear(); string s_table = AppFunc.GetSql(conStr, 1); string s_view = AppFunc.GetSql(conStr, 2); DataTable table1 = AppFunc.GetData(conStr, s_table); DataTable table2 = AppFunc.GetData(conStr, s_view); TreeNode rootNode = new TreeNode(conStr.Database); var nodes = treeView1.Nodes.Find(conStr.Database, false); if (nodes != null && nodes.Length > 0) { rootNode = nodes[0]; } else { treeView1.Nodes.Add(rootNode); } SetTreeview(1, rootNode, table1); SetTreeview(2, rootNode, table2); }