string sql = select count(id) as rcount from tbarticle where classid in( + ids + ) and title like @title ; 参数： sqliteparameter[] sps = new sqliteparameter[1]; sps[0] = sqlite.createparameter(@title, dbtype.string, % + title + %, 50, par
string sql = “select count(id) as rcount from tbarticle where classid in(” + ids + “) and title like @title “;
参数：
sqliteparameter[] sps = new sqliteparameter[1];
sps[0] = sqlite.createparameter(“@title”, dbtype.string, “%” + title + “%”, 50, parameterdirection.input);
就是在变量里直接模拟成 ‘%test%’ ，把这个传递进去，就可以查出结果了