access如何模糊參數(shù)進行分頁查詢代碼

    具體代碼如下：
    string sql = select count(id) as rcount from tbproduct where classid in( + ids + ) and productname like '%'+@productname+'%';
    oledbparameter[] sps = new oledbparameter[1];
    sps[0] = accessdb.createparameter(@productname, oledbtype.varchar, productname, 50, parameterdirection.input);
    int resultcount = (int)accessdb.executescalar(sql, sps);
    recordcount = resultcount;
    if (resultcount >= 0)
    {
    if ((resultcount % pagesize) == 0)
    {
    pagecount = resultcount / pagesize;
    }
    else
    {
    pagecount = (resultcount / pagesize) + 1;
    }
    if (pageindex == 1)
    {
    sql = select top + pagesize.tostring() + * from tbproduct where classid in( + ids + ) and productname like '%'+@productname+'%' order by id desc;
    }
    else
    {
    int minrecord = (pageindex - 1) * pagesize;
    sql = select top + pagesize.tostring() + * from tbproduct where id not in(select id from (select top + minrecord.tostring() + id from tbproduct where classid in( + ids + ) and productname like '%'+@productname+'%' order by id desc )tema) and classid in( + ids + ) and productname like '%'+@productname+'%' order by id desc;
    }
    }
    else
    {
    pagecount = 0;
    }
    return accessdb.executedataset(sql, sps).tables[0];