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
Can you use Web API with ASP.NET Web Form?
Why should i prefer JSP over asp.net or any other web development language..??
Explain the different types of directives in .net?
What is the displayafter property in updateprogress control?
if i wanna deploy my asp.net project to the production server and situation is that i m still not compiled my project i have as-is on my development side now on production server we dont have a visual studio now what kind of settings i need to be to do in webconfig /machine.config file to deploy my project and in iis too....
What are the uses of reflection?
How does u get record no from 5 to 15 from a dataset of 100 records?
Which authentication uses a combination of windows and iis authentication?
What are the two Layouts supported by a Web form in ASP.NET?
How you can access the properties and controls of master pages from content pages?
What is a server farm in iis?
What is server transfer?
How does session authentication work?
How can we inherit a static variable?
Difference between overriding and overloading?