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 ?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about consistent programming model in the .NET framework?

1183


Which namespace is used by ado.net?

1032


IN an ASP.NET Web application if there is any error, how can you debug?

1107


Describe a bubbled event and how it is used ?

1180


Give an example of what might be best suited to place in the application_start and session_start subroutines?

1016


How do you implement postback with a text box?

1038


What is a 404 redirect?

1101


What is the use of service provider?

1085


Define viewstate in .net?

1002


What is the exact purpose of http handlers?

1060


benefits of migration from asp to asp.net hi frnds, i have to give presentation to a client about how useful would be migrating their project from asp to asp.net .plz give me some points which i should incorporate in my ppt thanks

2406


9. Why should we hire you over the others waiting to be interviewed?

2861


What is the usie of activex control in .net?

1050


Can anyone please tell me that the question posted on this website are Sufficient for the interview with 2+ year experience in .net

2091


Explain what does wsdl stand for?

1230