c#winform winform接続oracleデータベース


private void button1_Click(object sender, EventArgs e)
        {
            MessageBox.Show(groupBox1, "    !");
            int count = 0;
            try
            {
                string ConnectionString = "Data Source=dzjc_2005;user=kk;password=kk;";//     
                OracleConnection conn = new OracleConnection(ConnectionString);//       

                conn.Open();
                OracleCommand cmd = conn.CreateCommand();
                cmd.CommandText = "select * from kk.kkyh";//    sql   
                OracleDataReader odr = cmd.ExecuteReader();//    OracleDateReader   
                while (odr.Read())//    ,  odr.Read()   false  ,            
                {
                    count++;
                    MessageBox.Show(odr.GetOracleString(1).ToString());//    1,        ,               
                }
                odr.Close();


                if (count > 0)
                {
                    MessageBox.Show(groupBox1, "    !");
                    this.Close();
                }
                else
                {
                    MessageBox.Show(groupBox1, "    !");
                }
            }
            catch (Exception ee)
            {
                MessageBox.Show(ee.Message.ToString());
            } 
        }


USing Systemを導入する必要がある.Data.OracleClient;
テストとしてのみ使用
 
黒い髪http://heisetoufa.iteye.com