using System;
using System.Data.OleDb;
using System.Collections.Generic;
using System.Text;

namespace Web.DataAccess
{
    public sealed class AccessHelperUtility
    {
        private AccessHelperUtility() { }

        public static Dictionary<string, OleDbParameter> OleDbParameterArrayToGDictionary(params OleDbParameter[] paras)
        {
            if (null == paras) throw new ArgumentNullException("paras");
            Dictionary<string, OleDbParameter> retval = new Dictionary<string, OleDbParameter>();
            foreach (OleDbParameter p in paras) retval.Add(p.ParameterName, p);

            return retval;
        }

        public static List<OleDbParameter> OleDbParameterGDictionaryToGList(Dictionary<string, OleDbParameter> paras)
        {
            if (null == paras) throw new ArgumentNullException("paras");

            List<OleDbParameter> retval = new List<OleDbParameter>();
            foreach (string k in paras.Keys) retval.Add(paras[k]);
            return retval;
        }

        public static OleDbParameter[] OleDbParameterGDictionaryToArray(Dictionary<string, OleDbParameter> paras)
        {
            if (null == paras) throw new ArgumentNullException("paras");

            List<OleDbParameter> retval = new List<OleDbParameter>();
            foreach (string k in paras.Keys)
                retval.Add(paras[k]);
            return retval.ToArray();
        }
    }
}

AccessHelperUtility.cs

AccessHelperUtility

data

C#