带VB的SqlDataAdapter分页ASP.NET [英] SqlDataAdapter paging asp.net with vb

问题描述

请任何人告诉我如何使用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.

这篇关于带VB的SqlDataAdapter分页ASP.NET的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！