Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 is considered a service provider?

952


Web API supports which protocol?

1372


What’s the use of “GLOBAL.ASAX” file?

1093


What is actually returned from server to the browser when a browser requests an .aspx file and the file is displayed?

1006


What is viewstate in asp net with example?

986


What is http session state?

968


Explain asp.net mvc request life cycle? : asp.net mvc

1065


How to find last error which occurred in Asp.net ?

1266


How can we prepairing Interview

2333


What is difference between mvc and asp.net? : Asp.Net MVC

1193


List the events in page life cycle.

963


Explain the difference between debug.write and trace.write? When should each be used?

1000


How can we register exception filter globally?

984


What is server infrastructure & server components?

1213


Can we add code files of different languages in app_code folder?

1097