Posted By

mn232nm on 11/02/08

Tagged

data

Versions (?)

Last Edited at 11/02/08 02:08am

Statistics

Viewed 550 times

Favorited by 0 user(s)

AccessHelperUtility

/ Published in: C#

AccessHelperUtility.cs

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

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();
        }
    }
}

Report this snippet Tweet

Comments

Subscribe to comments

Comment:

You need to login to post a comment.