c#链接Oracle

例：

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data.OracleClient;    //添加引用
using System.Data;

namespace bookInfo
{

 public class OracleDataBase
    {
        OracleConnection conn;
        OracleCommand cmd;
        OracleDataAdapter oda;
        string connString = "Data Source=ORCL;User Id=admin;Password=admin";

        //建立连接
        public OracleConnection getConn()
        {
            conn = new OracleConnection(connString);
            conn.Open();
            return conn;
        }

        //返回结果集
        public DataSet executeQuery(string sql,string tablename)
        {
           
            cmd = new OracleCommand(sql, conn);
            oda = new OracleDataAdapter(cmd);
            DataSet ds = new DataSet();
            oda.Fill(ds,tablename);
            conn.Close();
            cmd.Dispose();
            return ds;      
        }

        //建立执行返回行数
        public int executeUpdate(string sql)
        {
            try
            {
                cmd = new OracleCommand(sql, getConn());
                return cmd.ExecuteNonQuery();
            }
            catch
            {
                return 0;
            }
            finally
            {
                conn.Close();
            }
        }
    }