动态添加SqlParameter

List<SqlParameter> ilist = new List<SqlParameter>(); 
 
            ilist.Add(new SqlParameter("@Param1", "1"));
 
            ilist.Add(new SqlParameter("@Param2", "2"));
 
            ilist.Add(new SqlParameter("@Param3", "3"));
 
            ilist.Add(new SqlParameter("@Param4", "4"));
 
            ilist.Add(new SqlParameter("@ParamLike","%5%"));//Like的写法
 
   SqlParameter[] param = ilist.ToArray();

  

原文地址:https://www.cnblogs.com/TNSSTAR/p/2582316.html