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

What data types do the RangeValidator control support?

2 Answers   Siebel Systems,


What is boxing and how it is done internally?

1 Answers   Microsoft,


What is enableviewstatemac in asp net?

0 Answers  


How many classes can a single .NET DLL contain?

14 Answers   Siebel Systems,


List all templates of the repeater control.

0 Answers  


i want the asp.net technical questions and answeres

0 Answers  


What is the difference between Server.Transfer and Response.Redirect? Why would I choose one over the other?

3 Answers   Satyam,


What ?ll u do in early and late binding ?

1 Answers   DELL,


Write a code for "RequiredFieldValidator" in java script

5 Answers   Wipro,


Can we set master page as a start page?

0 Answers  


What are Master Pages in ASP.NET? or What is a Master Page?

0 Answers   MCN Solutions,


what are the main advantage in .net?

4 Answers   TCS,


Categories