日期:2014-05-18 浏览次数:20788 次
IQueryable<OITM> query = db.OITM;
  //for (int i = 0; i < list.Count;i++ )
  foreach (string keyword in ll)
  {
      string temp = keyword;
      query = query.Where(p => p.ItemName.Contains(temp));
        DbCommand cmd = db.GetCommand(query);
      string str = cmd.CommandText;
     foreach (DbParameter p in cmd.Parameters)
     {
      string pa = p.ParameterName;
      string va = p.Value.ToString();
     }
  }
------解决方案--------------------
  string pa="";
  string va= "";
foreach (DbParameter p in cmd.Parameters)
  {
  pa += p.ParameterName + " ,";
  va += p.Value.ToString() + " ,";;
  }