How do you implement Paging in .Net ?
Answer / gitam singh
The DataGrid provides the means to display a group of records from the data source (for example, the first 10), and then navigate to the "page" containing the next 10 records, and so on through the data.
Using Ado.Net we can explicit control over the number of records returned from the data source, as well as how much data is to be cached locally in the DataSet.
1.Using DataAdapter.fill method give the value of 'Maxrecords' parameter
(Note: - Don't use it because query will return all records but fill the dataset based on value of 'maxrecords' parameter).
2.For SQL server database, combines a WHERE clause and a ORDER BY clause with TOP predicate.
3.If Data does not change often just cache records locally in DataSet and just take some records from the DataSet to display.
| Is This Answer Correct ? | 0 Yes | 0 No |
What for use web.sitemap in asp.net?
How do I create a web form?
i want the asp.net technical questions and answeres
What is the typical session identifier?
Explain what benefit does your code receive if you decorate it with attributes demanding specific security permissions?
About CLS and CTS?
8 Answers Microsoft, Syncfusion,
Is it possible to disable the minimized icon of a popup window using window.open. Not using iframe concept?
is gateway for sms continue connected for sending sms.how?
How will you load dynamic assembly? How will create assesblies at run time?
Can user control be stored in library?
Explain server control extensibility with reference to asp.net 2.0 ?
How about the security in Activex DLL and Activex EXE ?
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)