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

how to convert varchar into datatype int............. in ASP

1 Answers  


ADO.Net - how to get data from database and bind to the controls -- write this small code

3 Answers   Syntel,


When should we use abtract class and Interface Class?Give an Example

4 Answers   Accenture, Cap Gemini, L&T, RM,


Which is better viewstate or session?

0 Answers  


Less than one page, how many windows will you be able to maintain?

0 Answers   Atos Origin,


how many session modes are available?some brief explnation

1 Answers  


What is virtual directory in asp.net?

0 Answers  


List of interview questions collections at www.dpoint.weebly.com

2 Answers   IBM,


What are all the ways to find out types of objects?

5 Answers   HCL,


How do you create a master page?

0 Answers  


What are the types of authentications in ASP.NET?

2 Answers   Accenture, BirlaSoft,


How we generate the BARCODE in ASP.Net using c# ! in library management systen for books .

2 Answers  


Categories