手机
当前位置:查字典教程网 >编程开发 >Access数据库 >Access 模糊参数 分页查询
Access 模糊参数 分页查询
摘要:复制代码代码如下:stringsql="SelectCount(ID)AsrcountFromTbProductWHEREclassIDIN...

复制代码 代码如下:

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];

【Access 模糊参数 分页查询】相关文章:

使用access数据库时可能用到的数据转换

Access9.7 汇总数据

Access2000如何创建索引

Access打造图书管理系统

mssql access top分页方法

Access6.5在表中复制和粘贴数据

Excel和Access之间的数据交换

Access模糊查询

Access报表打印如何自动分页

access 的页怎么用

精品推荐
分类导航