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 is query string with example?

0 Answers  


Trigger syntax in sql2000

1 Answers   Wipro,


What are the built-in objects in asp.net?

0 Answers  


what are the advantage in asp.net and what are the question ask for interview in vb.net and asp.net

0 Answers   TCS,


What is the most appropriate lifetime for a database connection/orm context in an asp.net mvc application? : Asp.Net MVC

0 Answers  


What is the difference between Trace and Debug?

2 Answers   BirlaSoft,


if i have placed the button control with the OnClick event like <asp:Button ID="mybutton" runat="server" Text="Insert" onclick="mybutton_Click" /> and some other controls(buttons, textboxes) in .aspx page. When i run the page, the button displays in the page source of the browser like <input type="submit" name="mybutton" value="Insert" id="mybutton" /> here, it does not display the onclick event, then how the page calls the button click on the server side, how the server side identify which button cause the submit, and how this page moves to the server side.

1 Answers  


What is the difference between an EXE and a DLL?

18 Answers   Infosys, JK Associates, Persistent, TATA, Technosoft, Wipro,


I M working in 1.1 .net framework. In a page I have 5 text box & 2 data grid. In PageLoad() All text box will populate with blank value & 1st dataGrid with some value. When I click on EDIT button Of the 1st dataGrid,The Relevent data Of the particular row will populate in first 3 textboxs & corresponding relevent data Will populate in the 2nd DataGrid. Now when I click 2nd datagrid's EDIT button of a perticular Row,relevent data will populate on last 2 textboxs & 1st 3 textbox's value will be same as per as it was........ ........My Problem Is ........... When I click on edit button Of 2nd DataGrid, 1st 3 text boxes values goes Off & 2nd DataGrid Is goes off Due to Postback.but The relevent value is populated In last 2 textboxes.So How I stoped this postback??So that all the data in 1st 3 textboxes will be same.So that I can edit the values of 2nd Grid with 1st 3 textBoxes value.. plz dirctly mail me 1 copy of post to... maloy.adhikari@in.com

2 Answers  


Explain the difference between singleton and single call?

0 Answers  


what are the oops concepts are used in your project?

1 Answers   AppShark, IBM, Kotak,


what are httphandlers and httpmodules.and their differences.

1 Answers   Siemens,


Categories