If i have 1000 records in dataset, how to do paging?

Answer Posted / arunbhararthi

you can use dataadapter fill method to implement paging in
dataset.

following is the syntax:

Public Overloads Function Fill(ByVal dataSet As DataSet,
ByVal startRecord As Integer, ByVal maxRecords As Integer,
ByVal srcTable As String) As Integer

WHERE dataSet is a DataSet to fill with records and, if
necessary, schema, startRecord is the zero-based record
number to start with, maxRecords is the maximum number of
records to retrieve, and srcTable is the name of the source
table to use for table mapping.which returns a DataSet
filled with the records based on the page size passed in the
method

for example:

da.fill(ds,0,100,"emp")

Is This Answer Correct ?    14 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are ASP.NET Web Forms? How is this technology different than what is available though ASP?

946


What is distributed system in asp.net?

546


What is the application pool?

552


If you are using components in your application, how can you handle exceptions raised in a component?

2083


How to use a Master Database in Asp.net?

570






What is the postback property in asp.net?

544


Which adapter should you use, if you want to get the data from an access database?

544


What is an example of an application service provider?

457


Which asp.net objects encapsulate the state of the client and the browser?

578


What is web api and why to use it?

562


Explain Apache web servers ? How can you get ASP.NET running in Apache web servers - why should you do this?

517


What is the main differences between asp and asp.net?

527


what is meant by sitemapnode ?

1507


what is publisher?

1652


Explain one critical mapping?

567