Thursday, February 28, 2013

Dynamic Parameter in command in ASP.net


        public SqlParameter[] GetParam(Hashtable objHT)
        {
            int count = objHT.Count;
            SqlParameter[] param=new SqlParameter[count];
            List<string> keys = new List<string>(objHT.Keys.OfType<string>());

            for (int i = 0; i < count; i++)
            {
                param[i] = new SqlParameter("@" + keys[i], objHT[keys[i]].ToString());
            }
            return param;
        }

No comments:

Post a Comment