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
What is inheritance and an how it be used, example with an example?
In a page I have gridview with options of select and delete using hyperlink when I am selecting any one of then it has to open another page how can it?
Asp pages that worked pefectly on windows 2000 server and iis 5.0 do not work on windows 2003 server with iis 6.0. Asp.net pages work fine. Why?
a web application needs to be created to accept the product name and quantity of a toy from a customer. After the customer has entered the product name the application needs to display the discounted price of the product to the customer (company is offering 35% discount on all products). The application should allow the customer to select the product name from a list box. and also while i'm data binding to a label with custom data binding with some declarations : "The Discounted Price is "+((System.Convert.todouble(lblprodprice.text)*(system.convert.todouble(txtqty.text)) - ((System.convert.todouble(lblprodprice.text)*(system.convert.todouble(txtqty.text)*0.35)). Where i need to give this declaration in asp.net 2.0.
What are the different types of Caching techniques in ASP.NET?
How asp.net mvc differs from asp.net web forms? : asp.net mvc
Can anyone please tell me that the question posted on this website are Sufficient for the interview with 2+ year experience in .net
What are the events that happen when a client requests an asp.net page from iis server?
What is the difference between c# and .net?
How many types of session state management options available in asp.net?
Why session is necessary in web application?
What is the difference between trace and debug in asp.net?
What is ViewState? What does the "EnableViewState" property do? Why would I want it on or off?
Tell me what is the request flow used for asp.net mvc framework? : asp.net mvc
What is a web farm?