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());
}