string sql = "select cus_id from VIP_Popedom where ',' + @userid + ',' like '%,' + rtrim(userid) + ','";
string strCustomerList = "";
SqlParameter[] parameters = {
new SqlParameter("@userid", SqlDbType.VarChar,100)};
parameters[0].Value = "1,2,3,45,234";
DataSet dsCustomerid = new DataSet();
dsCustomerid = Query(sql, parameters);
string strCustomerList = "";
SqlParameter[] parameters = {
new SqlParameter("@userid", SqlDbType.VarChar,100)};
parameters[0].Value = "1,2,3,45,234";
DataSet dsCustomerid = new DataSet();
dsCustomerid = Query(sql, parameters);
如果你想要出现多条记录,那么你就要保证你的SQL语句最后应该是变成诸如下面这样的样式:select cus_id from VIP_Popedom where userid in (1,2,3,....)所以你在执行
dsCustomerid = Query(sql, parameters);
方法之前,先把SQL变量打印出来,确保构造的SQL语句是上面那样,那么问题就解决了,如果没有,你就看看是哪的问题
string sql = "select cus_id from VIP_Popedom where ',' + @userid + ',' like '%,' + rtrim(userid) + ',%'";