日期:2014-05-18 浏览次数:20780 次
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() + " ,";;
}