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