private void DbShowTable() { string query = "SELECT TABLE_NAME FROM USER_TABLES WHERE UPPER(TABLE_NAME) LIKE UPPER('%@TABLENAME@%') ORDER BY TABLE_NAME"; query = query.Replace("@TABLENAME@", txtFindTable.Text.Trim()); con = new DBCon(query); con.DBFillData(dataGridView2); }
private void DbShowColumn(string tableName) { try { dataGridView3.DataSource = null; dataGridView3.Refresh(); } catch (System.Exception e) { System.Windows.Forms.MessageBox.Show(e.Message); } string query = "SELECT COLUMN_NAME, DATA_TYPE, DATA_LENGTH, NULLABLE FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = '@TABLENAME@'"; query = query.Replace("@TABLENAME@", tableName.Trim()); con = new DBCon(query); //con.DBConnect(); //con.DBDataSet(query); con.DBFillData(dataGridView3); }
//데이터를 가져와서 그리드에 보여준다. private void ShowData() { string query = ""; TextBox txtCrtl = new TextBox(); DataGridView dgv = new DataGridView(); txtCrtl = FindTextboxInTab(tabControl1.SelectedIndex); dgv = FindDgvInTab(tabControl1.SelectedIndex); if (txtCrtl.SelectedText.Trim() == "") { query = FindSelectQuery(txtCrtl.Text, txtCrtl.SelectionStart); } else { query = txtCrtl.SelectedText.Trim(); } con = new DBCon(query); con.DBFillData(dgv); //System.Windows.Forms.MessageBox.Show(con.pkCnt.ToString()); }