Access 模糊參數 分頁查詢

　　復制代碼 代碼如下:

　　string sql = Select Count(ID) As rcount From TbProduct WHERE classID IN( + ids + ) AND PRODUCTNAME LIKE %+@ProductName+%;
OleDbParameter[] sps = new OleDbParameter[];
sps[] = AccessDBCreateParameter(@ProductName OleDbTypeVarChar productName ParameterDirectionInput);
int resultCount = (int)AccessDBExecuteScalar(sql sps);
recordCount = resultCount;
if (resultCount >= )
{
if ((resultCount % pageSize) == )
{
pageCount = resultCount / pageSize;
}
else
{
pageCount = (resultCount / pageSize) + ;
}
if (pageIndex == )
{
sql = Select Top + pageSizeToString() + * From TbProduct WHERE classID IN( + ids + ) AND PRODUCTNAME LIKE %+@ProductName+% Order by ID desc;
}
else
{
int minRecord = (pageIndex ) * pageSize;
sql = Select Top + pageSizeToString() + * From TbProduct Where ID Not In(Select ID From (Select Top + minRecordToString() + 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 = ;
}
return AccessDBExecuteDataSet(sql sps)Tables[];

生活不易，碼農辛苦
如果您覺得本網站對您的學習有所幫助,可以手機掃描二維碼進行捐贈