C# 通过ado.net 访问oracle

1.安装ODP（oracle data provider）

2.然后在项目中引用 Oracle.DataAccess程序集

3.接着

using Oracle.DataAccess.Client;
using Oracle.DataAccess.Types;

 

4.然后编写程序和ado.net方位sqlserver 差别不大了，就是利用下面的对象进行编程，当然，因为oracle和sqlserver有很多地方不一样，所以细节存在很大差异。

 

OracleConnection

 

OracleCommand

        OracleParameter

 

OracleDataReader

 

OracleDataAdapter

 

5. 实例

例1： 根据部门ID 获取部门名称

            string oradb = "Data Source=TESTASM;User Id=hr;Password=hr;";
            OracleConnection conn = new OracleConnection(oradb);
            conn.Open();

            OracleParameter param = new OracleParameter();
            param.OracleDbType = OracleDbType.Decimal;
            param.Value = textBox1.Text;

            OracleCommand cmd = new OracleCommand();
            cmd.Connection = conn;
            
            cmd.Parameters.Add(param);
            cmd.CommandText = "select department_name from departments where department_id = :1";
           

            if(dr.Read())
            {

                  textBox1.Text = dr.GetString(1);

            }

            conn.Dispose();

 

实例2：获取所有部门信息

string oradb = "Data Source=TESTASM;User Id=hr;Password=hr;";
            OracleConnection conn = new OracleConnection(oradb);
            conn.Open();