利用SQL和DataGridView实现分页查询

Using SQL and DataGridView to Achieve Paging Query

为解决一次查询结果中,满足条件的记录条数过多而影响查询效率的问题,设计了分页查询,每次提交的SQL命令中,设定只返回指定的记录条数,从而减轻服务器负担,提高了查询效率。

In order to solve the problem that excessive number of records meeting the query conditions, which can affect query efficiency, we design paging query, each time one submit the SQL command returns only the specified number of records set, so as to reduce the burden on the server, to improve query efficiency.