private void button2_Click(object sender, System.EventArgs e)
{
string sqlText = "select * from SHEETMETADATA";
OracleDataAdapter oraAdapter = new OracleDataAdapter(sqlText, this.m_oraCmd.Connection);
DataSet ds = new DataSet();
oraAdapter.Fill(ds, "data");
frmPrintMetaData frmMD = new frmPrintMetaData(ds);
frmMD.Show();
this.Close();
}
private void button1_Click(object sender, System.EventArgs e) //查询按钮
{
if (txtquery.Text.Trim() == "")
{
MessageBox.Show("无查询语句！");
return;
}
string sqlText = "select * from SHEETMETADATA where " + this.txtquery.Text;
OracleDataAdapter oraAdapter = new OracleDataAdapter(sqlText, this.m_oraCmd.Connection);
DataSet ds = new DataSet();
oraAdapter.Fill(ds, "data");
if (ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("无查询结果！");
return;
}
frmPrintMetaData frmMD = new frmPrintMetaData(ds);
frmMD.Show();
this.Close();
}
private void button2_Click(object sender, System.EventArgs e)
{
string sqlText = "select * from SHEETMETADATA";
OracleDataAdapter oraAdapter = new OracleDataAdapter(sqlText, this.m_oraCmd.Connection);
DataSet ds = new DataSet();
oraAdapter.Fill(ds, "data");
frmPrintMetaData frmMD = new frmPrintMetaData(ds);
frmMD.Show();
this.Close();
}
//��ѯ��ť
private void button1_Click(object sender, System.EventArgs e)
{
if (txtquery.Text.Trim() == "")
{
MessageBox.Show("��ѯ��䣡");
return;
}
string sqlText = "select * from SHEETMETADATA where " + this.txtquery.Text;
OracleDataAdapter oraAdapter=new OracleDataAdapter(sqlText,this.m_oraCmd.Connection);
DataSet ds = new DataSet();
oraAdapter.Fill(ds,"data");
if (ds.Tables[0].Rows.Count == 0)
{
MessageBox.Show("��ѯ�����");
return;
}
frmPrintMetaData frmMD = new frmPrintMetaData(ds);
frmMD.Show();
this.Close();
}