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

Differentiate between authentication and authorization.

970


What are sql notifications and sql invalidations?

946


Which protocol is used to call a web service?

1052


What describes a query?

924


How to change Master page in ASP.Net using code?

1069


Explain the main differences between asp and asp.net?

1032


What is a web farm?

988


How to count the number of objects present in a web page? How to count the number of radio buttons in a web page?

1097


Is asp.net mvc front end or backend? : Asp.Net MVC

931


What is difference between inproc and outproc?

1141


What are tuples?

1137


How you will handle session when deploying application in more than a server?

1101


Why do we use web config?

939


What are type/key pairs in client script registration?

1071


Is sql backend or frontend?

1005