C#,oracle数据库操作基类,blob读写,返回数据集,调用存储过程

using System;

using System.Data;

using System.Windows.Forms;

using System.Data.OracleClient;

using System.Drawing;

using System.IO;

namespace ConvertData

{

    public class OracleOP

    {

        public OracleConnection Conn ;

        private OracleCommand cmd;

        //构造函数

        public OracleOP(string ConnectionStr)

        {

                       Conn = new OracleConnection(ConnectionStr);//string.Format("data source={0};user id= {1};password={2}", "landdb", "landuser", "land"));  //连接数据库

 

        }

        //打开数据源链接

        public bool Db_Conn()

        {

            try

            {

                Conn.Open();

                return true;

 

            }

            catch

            {

                return false;

            }

        }

        //返回DataReader数据集，下面的SQL可以动态生成

        public OracleDataReader Db_CreateReader(string SQL)

        {

            try

            {

 

                cmd = new OracleCommand(SQL, Conn);

                OracleDataReader Rs = cmd.ExecuteReader();

 

                return Rs;

            }

            finally

            {

 

            }

        }

        //返回DataReader数据集，下面的SQL是存储过程

        public OracleDataReader Db_CommandReader(string SQL)

        {

            try

            {

 

                cmd = new OracleCommand(SQL, Conn);

                cmd.CommandType = CommandType.StoredProcedure;

                OracleDataReader Rs = cmd.ExecuteReader();

                return Rs;

            }

            finally

            {

 

            }

        }

        //返回数据DataSet数据集

        public OracleDataAdapter Adpt;

        public DataSet Db_CreateDataSet(string SQL)

        {

            try