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 |
RequiredFieldValidator--write code in javascript
What is difference between datalist and gridview?
What are different ASP.NET Web Forms with the technology different from though ASP (1.0-3.0)?
Can we make a class with class with same;suppose public class abc { public class abc { } }
What are different transaction options?
How do you define authentication in Web.Config?
2 Answers Accenture, BirlaSoft, IBM,
How many types of Cookies are available in ASP.NET?
What asp.net control can embed xaml into asp.net pages?
What is global.asax file used for?
What do you mean by role-based security?
What is AutoPostback?
I have to send data throug querystring from one page to another. But it should not be displayed in URL. How it is possible?
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)