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
Differentiate between authentication and authorization.
What are sql notifications and sql invalidations?
Which protocol is used to call a web service?
What describes a query?
How to change Master page in ASP.Net using code?
Explain the main differences between asp and asp.net?
What is a web farm?
How to count the number of objects present in a web page? How to count the number of radio buttons in a web page?
Is asp.net mvc front end or backend? : Asp.Net MVC
What is difference between inproc and outproc?
What are tuples?
How you will handle session when deploying application in more than a server?
Why do we use web config?
What are type/key pairs in client script registration?
Is sql backend or frontend?