这是我的查询:
"select cli.FANTASIA, dbsmp.VEICULO_PLACA, dbsmp.DTINICIOPREV, dbsmp.DTFIMPREV," +
" dbsmp.DTINICIOREAL, dbsmp.DTFIMREAL,dbsmp.CIDADE_DES,dbsmp.CIDADE_ORI, work.STATUS," +
" dbsmp.REF1 FROM dbsmp_work work inner join dbsmp "+
" on work.ID_SMP = dbsmp.ID_SMP inner join dbcliente cli "+
" on dbsmp.ID_CLIENTE = cli.ID_CLIENTE inner join dbSMP_MOTORISTA mot "+
" on dbsmp.ID_SMP = mot.ID_SMP where dbsmp.ID_CLIENTE = @IDCLIENTE "+
" and work.STATUS in('F') and work.tipo in ({0})";
在
{0}
点,我要插入由,
分隔的字符串列表。有没有办法使用某种方法或类似的方法传递此列表,或者我将不得不手动创建另一个字符串,例如。在列表中循环播放?
最佳答案
尝试这个:
string.Format(sql, "'" + string.Join("', '", arrOfStrings) + "'")