用C#如何连接Oracle数据库并且进行操作

[sunhongxiang]

各位大虾 ，本人刚刚接触ORCLE数据库，对该数据库一点都不懂，请大家指教一下，如何连接数据库并且进行操作

[tangserver]

//首先添加两条引用
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(); //关闭连接
}
}

[llsen]

和sql差不多啊

只是类换乘orl类了

[jiang_jiajia10]

http://www.cnblogs.com/tech-faraWay/archive/2006/07/10/446813.html

 using System.Data.OracleClient;
 public class ORCLDataAccess:DAO
    {
        //数据库连接对像
        private OracleConnection conn = null;
        //数据库命令对像
        private OracleCommand cmd = new OracleCommand();
        //DataAdapter对像
        private OracleDataAdapter adapter = new OracleDataAdapter();

        private OracleParameter parameter = new OracleParameter();

        private OracleDataReader reader = null;

        private OracleTransaction trans = null;
        /// <summary>
        /// 该实例使用的数据库连接字符串
        /// </summary>
        private string connectionString = ApplicationConfiguration.DBConnectionString;

        connectionString =“user id=bsrs_sys;data source=BNURS_COMPUTER1;password=sys”；
        #region DAO 成员
        /// <summary>
        /// 数据库类型
        /// </summary>
        public System.Data.DbType DatabaseType
        {
            get
            {
                return new System.Data.DbType();
            }
        }
        /// <summary>
        /// 数据库DataReader对像
        /// </summary>
        public System.Data.IDataReader DataReader
        {
            get
            {
                return this.reader;
            }
            set
            {
                reader = (OracleDataReader)value;
            }
        }

        public System.Data.IDbConnection DbConnection
        {
            get
            {
                if (conn == null)
                {
                    conn = new OracleConnection(connectionString);
                }
                return conn;
            }
        }

        /// <summary>
        /// 执行命令类型
        /// </summary>
        public System.Data.CommandType Commandtype
        {
            set { throw new Exception("The method or operation is not implemented."); }
        }

        public System.Data.IDbCommand DataCommand
        {
            get
            {
                return this.cmd;
            }
            set
            {
                cmd = (OracleCommand)value;
            }
        }

        public System.Data.IDbDataParameter NewParameter(string parameterName, System.Data.DbType dbType)
        {
            throw new Exception("The method or operation is not implemented.");
        }

        /// <summary>
        /// 参数设置
        /// </summary>
        /// <param name="parameterName"></param>
        /// <param name="dbType"></param>
        /// <param name="size"></param>
        /// <returns></returns>
        public System.Data.IDbDataParameter NewParameter(string parameterName, System.Data.DbType dbType, int size)
        {
            throw new Exception("The method or operation is not implemented.");
        }

        /// <summary>
        /// OracleDataAdapter
        /// </summary>
        public System.Data.IDbDataAdapter DataAdapter
        {
            get
            {
                if (adapter != null)
                {
                    return adapter;
                }
                else
                {
                    adapter = new OracleDataAdapter();
                    return adapter;
                }
            }
        }
        /// <summary>
        /// 打开数据库连接
        /// </summary>
        public void Open()
        {
            if (connectionString == null)
            {
                connectionString = System.Configuration.ConfigurationSettings.AppSettings["myConnection"];
            }

            if (conn == null)
            {
                conn = new OracleConnection(connectionString);
                conn.Open();
            }
            else
            {
                if (conn.State == ConnectionState.Closed)
                    conn.Open();
            }
        }

        /// <summary>
        /// 关闭数据库连接
        /// </summary>
        public void Close()
        {
            if (conn != null&&conn.State == ConnectionState.Open)
            {
                conn.Close();
            }
        }

        /// <summary>
        /// 开始执行数据库事务
        /// </summary>
        /// <returns></returns>
        public System.Data.IDbTransaction BeginTransaction()
        {
            Open();
            trans = conn.BeginTransaction();
            return trans;
        }
        /// <summary>
        /// 开始数据库连接
        /// </summary>
        /// <param name="isolationLevel"></param>
        /// <returns></returns>
        public System.Data.IDbTransaction BeginTransaction(IsolationLevel isolationLevel)
        {
            Open();

            trans = conn.BeginTransaction(isolationLevel);

            return trans;
        }
        /// <summary>
        /// 执行无返回值的操作
        /// </summary>
        /// <param name="commandText">数据操作字符串</param>
        /// <returns>返回影响的行数</returns>
        public int ExecuteNonQuery(string commandText)
        {
            Open();
            int rValue = 0;
            cmd.Connection = conn;
            try
            {
                cmd.CommandText = commandText;
                cmd.CommandType = CommandType.Text;
                rValue = cmd.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                throw e;
            }
            return rValue;
        }
        /// <summary>
        /// 执行无返回值的数据操作命令
        /// </summary>
        /// <returns>返回影响的行数</returns>
        public int ExecuteNonQuery()
        {
            Open();
            int rValue = 0;
            cmd.Connection = conn;
            try
            {
                rValue = cmd.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                throw e;
            }
            return rValue;
        }
      

[jiang_jiajia10]

http://www.cnblogs.com/tech-faraWay/archive/2006/07/10/446813.html

 using System.Data.OracleClient;
 public class ORCLDataAccess:DAO
    {
        //数据库连接对像
        private OracleConnection conn = null;
        //数据库命令对像
        private OracleCommand cmd = new OracleCommand();
        //DataAdapter对像
        private OracleDataAdapter adapter = new OracleDataAdapter();

        private OracleParameter parameter = new OracleParameter();

        private OracleDataReader reader = null;

        private OracleTransaction trans = null;
        /// <summary>
        /// 该实例使用的数据库连接字符串
        /// </summary>
        private string connectionString = ApplicationConfiguration.DBConnectionString;

        connectionString =“user id=bsrs_sys;data source=BNURS_COMPUTER1;password=sys”；
        #region DAO 成员
        /// <summary>
        /// 数据库类型
        /// </summary>
        public System.Data.DbType DatabaseType
        {
            get
            {
                return new System.Data.DbType();
            }
        }
        /// <summary>
        /// 数据库DataReader对像
        /// </summary>
        public System.Data.IDataReader DataReader
        {
            get
            {
                return this.reader;
            }
            set
            {
                reader = (OracleDataReader)value;
            }
        }

        public System.Data.IDbConnection DbConnection
        {
            get
            {
                if (conn == null)
                {
                    conn = new OracleConnection(connectionString);
                }
                return conn;
            }
        }

        /// <summary>
        /// 执行命令类型
        /// </summary>
        public System.Data.CommandType Commandtype
        {
            set { throw new Exception("The method or operation is not implemented."); }
        }

        public System.Data.IDbCommand DataCommand
        {
            get
            {
                return this.cmd;
            }
            set
            {
                cmd = (OracleCommand)value;
            }
        }

        public System.Data.IDbDataParameter NewParameter(string parameterName, System.Data.DbType dbType)
        {
            throw new Exception("The method or operation is not implemented.");
        }

        /// <summary>
        /// 参数设置
        /// </summary>
        /// <param name="parameterName"></param>
        /// <param name="dbType"></param>
        /// <param name="size"></param>
        /// <returns></returns>
        public System.Data.IDbDataParameter NewParameter(string parameterName, System.Data.DbType dbType, int size)
        {
            throw new Exception("The method or operation is not implemented.");
        }

        /// <summary>
        /// OracleDataAdapter
        /// </summary>
        public System.Data.IDbDataAdapter DataAdapter
        {
            get
            {
                if (adapter != null)
                {
                    return adapter;
                }
                else
                {
                    adapter = new OracleDataAdapter();
                    return adapter;
                }
            }
        }
        /// <summary>
        /// 打开数据库连接
        /// </summary>
        public void Open()
        {
            if (connectionString == null)
            {
                connectionString = System.Configuration.ConfigurationSettings.AppSettings["myConnection"];
            }

            if (conn == null)
            {
                conn = new OracleConnection(connectionString);
                conn.Open();
            }
            else
            {
                if (conn.State == ConnectionState.Closed)
                    conn.Open();
            }
        }

        /// <summary>
        /// 关闭数据库连接
        /// </summary>
        public void Close()
        {
            if (conn != null&&conn.State == ConnectionState.Open)
            {
                conn.Close();
            }
        }

        /// <summary>
        /// 开始执行数据库事务
        /// </summary>
        /// <returns></returns>
        public System.Data.IDbTransaction BeginTransaction()
        {
            Open();
            trans = conn.BeginTransaction();
            return trans;
        }
        /// <summary>
        /// 开始数据库连接
        /// </summary>
        /// <param name="isolationLevel"></param>
        /// <returns></returns>
        public System.Data.IDbTransaction BeginTransaction(IsolationLevel isolationLevel)
        {
            Open();

            trans = conn.BeginTransaction(isolationLevel);

            return trans;
        }
        /// <summary>
        /// 执行无返回值的操作
        /// </summary>
        /// <param name="commandText">数据操作字符串</param>
        /// <returns>返回影响的行数</returns>
        public int ExecuteNonQuery(string commandText)
        {
            Open();
            int rValue = 0;
            cmd.Connection = conn;
            try
            {
                cmd.CommandText = commandText;
                cmd.CommandType = CommandType.Text;
                rValue = cmd.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                throw e;
            }
            return rValue;
        }
        /// <summary>
        /// 执行无返回值的数据操作命令
        /// </summary>
        /// <returns>返回影响的行数</returns>
        public int ExecuteNonQuery()
        {
            Open();
            int rValue = 0;
            cmd.Connection = conn;
            try
            {
                rValue = cmd.ExecuteNonQuery();
            }
            catch (Exception e)
            {
                throw e;
            }
            return rValue;
        }