请教，c#如何访问Oracle数据库？

cofei

public bool RunProcedure(string ReturnParameter,OracleType ParamType,ref DataSet Dataset,Hashtable HT ,string ProcedureName,string OracleConnection)
  {
   System.Data.OracleClient.OracleConnection dsconnection = new System.Data.OracleClient.OracleConnection(OracleConnection);
   System.Data.OracleClient.OracleCommand dacommand = new System.Data.OracleClient.OracleCommand(ProcedureName,dsconnection);
   dsconnection.Open();
   dacommand.CommandType=CommandType.StoredProcedure;
   IDictionaryEnumerator Enumerator;
   Enumerator = HT.GetEnumerator();
   object Value=null;
   OracleParameter OracleParam;
   OracleParam = dacommand.Parameters.Add(new OracleParameter(ReturnParameter,ParamType));
   OracleParam.Direction = ParameterDirection.Output;
   while(Enumerator.MoveNext())
   {
    Value = Enumerator.Value;
    OracleParam=dacommand.Parameters.Add(new OracleParameter(Enumerator.Key.ToString(), Value));
   }
   OracleDataAdapter ODAdapter=new OracleDataAdapter(dacommand);
            try
   {
    ODAdapter.Fill(Dataset);
     return true;
   }
   catch(System.Exception e)
   {
    e.ToString();
    return false;
   }
   finally
   {   
    HT.Clear();
    dacommand.Parameters.Clear();
    dsconnection.Close();
   }
}

twriter

using System.Data.OracleClient;using System.Data;//在窗体上添加一个按钮，叫Button1，双击Button1，输入以下代码private void Button1_Click(object sender, System.EventArgs e){string ConnectionString="Data Source=sky;user=system;password=manager;";//写连接串OracleConnection conn=new OracleConnection(ConnectionString);//创建一个新连接try{conn.Open();OracleCommand cmd=conn.CreateCommand();cmd.CommandText="select * from MyTable";//在这儿写sql语句OracleDataReader odr=cmd.ExecuteReader();//创建一个OracleDateReader对象while(odr.Read())//读取数据，如果odr.Read()返回为false的话，就说明到记录集的尾部了           {Response.Write(odr.GetOracleString(1).ToString());//输出字段1，这个数是字段索引，具体怎么使用字段名还有待研究}odr.Close();}catch(Exception ee){Response.Write(ee.Message); //如果有错误，输出错误信息}finally{conn.Close(); //关闭连接}}

cnhzlt

老帖又翻起啊