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 is the answer for "Which configuration Tool your using means" ? we have to tell about IIS or .Net Framework or VSS? Give me in brief ?
What does postback mean?
Am not able to move the controls on the form freely in asp.net 3.5 even though I selected the position as relative or absolute for those controls. What should I do to overcome this?
explain store procedure and trigger
What are uri parameters?
When we use cookie less session? Explain its working?
0 Answers Sans Pareil IT Services,
When maintaining session through Sql server, what is the impact of Read and Write operation on Session objects? will performance degrade..
3 Answers Allsec Technologies,
how can i insert array values and retreive in asp.net
What is asp.net file?
How many types of session state management options available in asp.net?
Can I combine classic asp and asp.net pages?
Why does my asp.net file have multiple tag with runat=server?
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)