带VB的SqlDataAdapter分页ASP.NET
问题描述：
请任何人告诉我如何使用sqldataadapter在asp.net中进行分页.
please anyone tell me how to paging in asp.net with sqldataadapter.
Dim adapter As SqlDataAdapter
adapter = New SqlDataAdapter(sqlcommand)
Dim ds As New Data.DataSet
Try
adapter.Fill(ds)
答
分页是通过控件完成的，该控件从数据库中获取期望的记录，或者仅从已获取的数据中选择所需的记录.
SQLDataAdapter没有分页. SQLDataAdapter是ADO.NET的一种方法，它基于命令填充数据集(可在断开连接模式下使用)的命令从数据库获取数据.
Pagination is done via controls that fetch the expected records from database or just pick the needed records from already fetched data.
There is no pagination for SQLDataAdapter. SQLDataAdapter is a ADO.NET way to get data from database based on a command that fills the dataset which can be used in disconnected mode.