Пример #1
0
        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();
        }
Пример #2
0
        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();
        }
Пример #3
0
 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();
 }
Пример #4
0
        //��ѯ��ť
        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();
        }