c#连接oracle数据库，查询数据

简单的访问数据库的方法：   

         OracleConnection oConnection = new OracleConnection("Data Source= Source;User ID=User ID;Password=Password;Pooling=FALSE");
            OracleDataReader oRead = null;
            try
            {
                oConnection.Open();

                OracleCommand oCommand = oConnection.CreateCommand();
                oCommand.CommandText = "select * from TABLE1 where 字段1 =:p1";

                oCommand.Parameters.Add(new OracleParameter("p1", OracleDbType.Varchar2, 22)).Value =参数值1

                oRead = oCommand.ExecuteReader();
            }
            finally
            {
                if (oRead != null && !oRead.IsClosed)
                {
                    oRead.Close();
                }
                oConnection.Close();
            }

 

简单整理一下，以备日后查用。