我这样做
selectSql = "select sum(bonus) as bonus,from Bonus where id in (@id);
saleList ="222,333,444";
selectCommand.Parameters.Add("@id",saleList);//????系统检索错误!
selectSql = "select sum(bonus) as bonus,from Bonus where id in (@id);
saleList ="222,333,444";
selectCommand.Parameters.Add("@id",saleList);//????系统检索错误!
selectSql = "select sum(bonus) as bonus,from Bonus where id in (";
saleList = "222,333,444";
selectSql = selectSql + saleList +")";不用参数。
我不是用动态生成的SQL,
我是通过使用selectCommand.Parameters.Add指定参数的,
而且我的id参数是字符型的。
EATSAHARA(再生RML) 的正解