在没有OR条件是‘)’收在and条件后面。我是初级菜鸟,所以......
foreach (string item in list) { if (where == string.Empty) { where += "and ([TT_Price_ItemID] = '" + item.Trim() + "' "; } else { where += " or [TT_Price_ItemID] = '" + item.Trim() + "'";
} }
where += ") ";
foreach (string item in list) { if (where == string.Empty) { where += "and ([TT_Price_ItemID] = '" + item.Trim() + "' "; } else { where += " or [TT_Price_ItemID] = '" + item.Trim() + "'"; } } where += ") "; 歡迎參觀我的Blog.NET菜鳥自救會