StringsqlSelectCount (ID) AsrcountFromtbArticleWHEREclassIDIN (+ ids +) ANDTitleLIKE @ Title; parameter: SQLiteParameter [] spsnewSQLiteParameter [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; parameter: 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";
Parameters:
SQLiteParameter [] sps = new SQLiteParameter [1];
Sps [0] = SQLite. CreateParameter ("@ Title", DbType. String, "%" + title + "%", 50, ParameterDirection. Input );
It is directly simulated into '% test %' in the variable, pass this in, you can find the result.