如题 dOOdads 连接 ACCESS 的数据分页问题！
使用 dOOdads 连接 ACCESS数据的时候 数据分页的问题！
根据这个改吧
C# code:
public static Product[] SearchProducts(string keyword, int categoryID, int pageSize, int pageIndex, out int total)
{
OleDbConnection connection = new OleDbConnection(ConnectionString);
// 建立查询，查出满足条件产品的总数
OleDbCommand countCommand = connection.CreateCommand();
countCommand.CommandText = "SELECT COUNT(ProductID) from tblProducts ";
string where = "WHERE Active > 0 ";
if (categoryID > 0)
{
where = where + "AND CategoryID = " + categoryID.ToString() + " ";
}
if (!string.IsNullOrEmpty(keyword))
{
where = where + "AND ProductName LIKE '%" + keyword + "%' ";
}
countCommand.CommandText += where;
DataTable dt = new DataTable();
try
{
connection.Open();
total = (int)countCommand.ExecuteScalar();
if (total < 1) return null; // 没有记录返回空（null）
int maxPageNum = (total % pageSize == 0 ? total / pageSize : total / pageSize + 1);
dwr.xml:
<create creator="struts" javascript="PrisonerActionForm">
<param name="formBean" value="prisonerForm"/>
< ......
