C#与数据库(1)

dataset

        public DataSet GetDataSet(string SQL,OracleParameter[] parameter,OracleConnection conn)
        {
            OracleDataAdapter adapter=new OracleDataAdapter();
            adapter.SelectCommand=new OracleCommand(SQL,conn);
            if (parameter!=null)
            {
                foreach(OracleParameter parameters in parameter)
                {
                    adapter.SelectCommand.Parameters.Add( parameters );
                }
            }
            DataSet DS=new DataSet();
            adapter.Fill(DS);
            return DS;
        }

//---

public DataSet dataSet(string sqlString,string tableName,OracleParameter[] parameter)
        {
            OracleConnection conn=new OracleConnection(getConString());
            OracleDataAdapter adapter=new OracleDataAdapter();
            adapter.SelectCommand=new OracleCommand(sqlString,conn);
            if (parameter!=null)
            {
                foreach(OracleParameter parameters in parameter)
                {
                    adapter.SelectCommand.Parameters.Add( parameters );
                }
            }
            DataSet DS=new DataSet();
            adapter.Fill(DS,tableName);
            return DS; 
        }
        public DataView dataView(string sqlString,string tableName,OracleParameter[] parameter)
        {
            OracleConnection conn=new OracleConnection(getConString());
            OracleDataAdapter adapter=new OracleDataAdapter();
            adapter.SelectCommand=new OracleCommand(sqlString,conn);
            if (parameter!=null)
            {
                foreach(OracleParameter parameters in parameter)
                {
                    adapter.SelectCommand.Parameters.Add( parameters );
                }
            }
            DataSet DS=new DataSet();
            adapter.Fill(DS,tableName);
            DataView DV;
            DV=new DataView(DS.Tables[0]);
            return DV; 
        }
        public void delete(string sqlString,OracleParameter[] parameter)
        {
            OracleConnection conn=new OracleConnection(getConString());
            conn.Open();
            OracleCommand cmd=new OracleCommand(sqlString,conn);
            if (parameter!=null)
            {
                foreach(OracleParameter parameters in parameter)
                {
                    cmd.Parameters.Add( parameters );
                }
            }
            cmd.ExecuteNonQuery();
            conn.Close();
        }
        public void execProcedure(string procedureName,OracleParameter[] parameter)
        {
            OracleConnection conn=new OracleConnection(getConString());
            conn.Open();
            OracleCommand cmd=new OracleCommand();
            cmd.Connection=conn;
            cmd.CommandType=CommandType.StoredProcedure;
            cmd.CommandText=procedureName;
            if (parameter!=null)
            {
                foreach(OracleParameter parameters in parameter)
                {
                    cmd.Parameters.Add( parameters );
                }
            }
            cmd.ExecuteNonQuery();
            conn.Close();
        }
        public void InsertOrEdit(string sqlString,OracleParameter[] parameter)
        {
            OracleConnection conn=new OracleConnection(getConString());
            conn.Open();
            OracleCommand cmd=new OracleCommand(sqlString,conn);
            if (parameter!=null)
            {
                foreach(OracleParameter parameters in parameter)
                {
                    cmd.Parameters.Add( parameters );
                }
            }
            cmd.ExecuteNonQuery();
            conn.Close();
        }

        public OracleConnection OraConn()
        {
            string Con_str ="user id=call;data source=dbcenter;password=XXX;pooling=false";
            OracleConnection conn1 = new OracleConnection(Con_str);
            return conn1;
        }