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;
只作为测试使用