通过查询结果进行分页牛

public static void GetData(string direction)

{

// 创建返回一页记录的SQL语句

ear();

switch (direction)

{

case \"下一页\":

mandText = \"SELECT TOP \" + pageSize + \" CustomerID, CompanyName FROM Customers \" +

\"WHERE CustomerID @CustomerId ORDER BY CustomerID\";

d(\"@CustomerId\", rChar, 5).Value = lastVisibleCustomer;

break;

case \"前一页\":

mandText = \"SELECT TOP \" + pageSize + \" CustomerID, CompanyName FROM Customers \" +

\"WHERE CustomerID @CustomerId ORDER BY CustomerID DESC\";

d(\"@CustomerId\", rChar, 5).Value = firstVisibleCustomer;

break;

default:

mandText = \"SELECT TOP \" + pageSize + \" CustomerID, CompanyName FROM Customers ORDER BY CustomerID\";

// 计算总页数

SqlCommand totCMD = new SqlCommand(\"SELECT Count(*) FROM Customers\", nwindConn);

en();

int totalRecords = (int)ecuteScalar();

ose();

totalPages = (int)iling((double)totalRecords / pageSize);

break;

}

// 用查询结果填充临时表

DataTable tmpTable = new DataTable(\"Customers\");

int recordsAffected = ll(tmpTable);

// 如果表不存在，就创建

if (custTable == null)

custTable = one();

// 如果有记录返回，就刷新表

if (recordsAffected 0)

{

switch (direction)

{

case \"下一页\":

currentPage++;

break;

case \"上一页\":

currentPage--;

break;

default:

但对于此次四连跌的出现 currentPage = 1;

break;

}

xt = \"第\" + currentPage + \"/ \" + totalPages + \"页\";

// 清除行集，添加新记录

ear();

foreach (DataRow myRow in ws)

portRow(myRow);

// 保存first 和 last 关键值

DataRow[] ordRows = lect(\"\", \"CustomerID ASC\");

firstVisibleCustomer = ordRows[0][0].ToString();

lastVisibleCustomer = ordRows[unt - 1][0].ToString();

}

}

public PagingSample()

{

// 初始化控件并添加到Form

ientSize = new Size(360, 274);

xt = \"NorthWind 数据表\";

cation = new Point(10,10);

ze = new Size(340, 220);

lowSorting = true;

ptionText = \"NorthWind 客户信息\";

adOnly = true;

lowNavigation = false;

eferredColumnWidth = 150;

xt = \"前一页\";

ze = new Size(60, 24);

cation = new Point(50, 240);

ick += new EventHandler(Prev_OnClick);

xt = \"下一页\";

ze = new Size(60, 24);

cation = new Point(120, 240);

xt = \"没有记录返回\";

ze = new Size(130, 16);

cation = new Point(200, 244);

d(myGrid);

d(prevBtn);

d(nextBtn);

d(pageLbl);

ick += new EventHandler(Next_OnClick);

// 计算默认的第一页，并进行绑定

GetData(\"Default\");

DataView custDV = new DataView(custTable, \"\", \"CustomerID\", rrentRows);

tDataBinding(custDV, \"\");

}

public static void Prev_OnClick(object sender, EventArgs args)

{

GetData(\"前一页\");

}

public static void Next_OnClick(object sender, EventArgs args)

{

GetData(\"下一页\");

}

}

查看本文来源

常州治疗白癜风的医院
西安男科治疗医院
小儿积食吃什么药