动态添加SqlParameter

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35

Dictionary<string, object> mDic = new Dictionary<string, object>();   if (!string.IsNullOrEmpty(MerchantName))   {   mDic.Add("@MerchantName", "%" + MerchantName + "%" );   }        foreach (var item in mDic)   {   ilist.Add(new SqlParameter(item.Key, item.Value));   }   foreach (var item in ilist)   {   if (item.ToString()== "@MerchantName")   {   cmdText += "AND a.UserName LIKE "+item+"";   }   }