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 a 1x1 pixel?
What permissions do asp.net applications posses by default?
What is anonymous authentication?
What is the difference between asp.net mvc and asp.net webforms? : asp.net mvc
What is web.config and machine.config ?
3 Answers Collabor, NDPL, TCS,
How to create discussion forum in asp.net mvc? : Asp.Net MVC
what is webservices. howit is use in our project .
What is the Global.asax used for?
Why we use asp.net for website development?
What is the use of web.config file?
What are the type of session in Asp.Net
What is x xss protection?
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)