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 are session state modes? List some of the important session state modes of asp.net.

1010


What is comparevalidator?

1030


Explain the difference between asp.net mvc and asp.net webforms? : asp.net mvc

1088


What are the 3 levels at which content pages can be attached to Master Page?

1244


Explain authorization levels in .net ?

1088


What are the advantages of the code-behind feature?

1051


What is a nested masterpage in asp.net 2.0? Can there be a master page inside a masterpage?

950


What is difference between abstract class and an interface?

993


Explain the use of view state?

1069


Is LINQ performance wise better or using sqlcommand?

5173


How will you maintain versioning in asp.net 2.0?

1075


Is session server side or client side?

1018


How can you identify that the page is post back?

1061


If I am developing an application that must accomodate multiple security levels though secure login and my asp.net web application is spanned across three web-servers (using round-robin load balancing). What would be the best approach to maintain login-in state for the users?

1141


Define msil.

1018