If i have 1000 records in dataset, how to do paging?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / sunil kumar singh
for(int i=0;i<ds.Count;i++)
{
arraylist arr=new arraylist();
string abc;
abc=ds.Tables["tablename"].Rows[0][i].ToString();
arr.Add(abc);
}
| Is This Answer Correct ? | 4 Yes | 9 No |
What is the difference between HTTP-Post and HTTP-Get ?
Difference b/w casting and boxing?
What is state management techniques in asp.net?
You have been given the task of designing a web services to expose the data that is stored in a database on the server. In order to successfully build the web services, you need to import some namespaces. What is the minimum namespace you need to import? a) System.Web b) System.WebServices c) System.Web.Services d) System.Web.ServiceModel
What’s the difference between Response.Write() andResponse.Output.Write()?
what are types of viewstate
In asp.net, if a webpage seems too slow to load completely in th ebrowser. In this case what are the checkings or actions you will take to rectify the slowness or which are the factors related to this issue? How we can trace it?
Where would you use an iHTTPModule, and what are the limitations of any approach you might take in implementing one
How can we Deploy a website?
What is the difference between globalization and localization?
Explain the asp.net session state modes.
What is an Interface and What is an Abstract Class?
Visual Basic (800)
C Sharp (3816)
ASP.NET (3180)
VB.NET (461)
COM+ (79)
ADO.NET (717)
IIS (369)
MTS (11)
Crystal Reports (81)
BizTalk (89)
Dot Net (2435)
Exchange Server (362)
SharePoint (720)
WCF (340)
MS Office Microsoft (6963)
LINQ Language-Integrated Query (317)
WPF (371)
TypeScript (144)
Microsoft Related AllOther (311)