Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How do you implement Paging in .Net ?



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

Post New Answer

More ASP.NET Interview Questions

I am opening Crystal Report in asp.Net 3.5. Report is opening very well but when I click on Refresh button of Crystal Report then it gives "Missing Parameter values" I also tried property of CR Viewer like crViewer.ReuseParameterValuesOnRefresh = True But it is not working. Plz give me solution.

1 Answers  


Mention the namespace that is used to include .net data provider for sql server in .net code?

0 Answers  


what is wpf and wcf in .net explain with an example?

2 Answers  


In your ASP.NET 2.0 web application you want to display an image that is selected from a collection of images. What approach will you use to implementing this?

0 Answers   HCL,


under which namespaces connection strings can be defined?

4 Answers  


What is server objects in asp.net?

5 Answers  


Explain the advantages of asp.net.

0 Answers  


Asp.Net Source :- In my project i have gridview control - item template. Its have asp:button control. my requirement is while click this button i need to display some alert message. Could you please help me which gridview event i need to write source code? Please give me a quick response. Thanks

6 Answers  


Which namespace is used by ado.net?

0 Answers  


How you can access the properties and controls of master pages from content pages?

0 Answers  


Difference between ASP & ASP.NET Session State

1 Answers   Cognizant, Wipro,


What are generics? why it is used? architecture of ASP.NET?

7 Answers   Path Infotech, Satyam, TCS,


Categories