GridView: How to set the number of rows to display

Question

I would like my grid view to display only 3 rows any ideas on how I can achieve this?

Thanks

Answer 1

Enable Paging and set the GridView's PageSize to 3.

How to: Enable Default Paging in the GridView Web Server Control

If you want to restrict your GridView to show only 3 rows without paging, you need to use a DataSource with only 3 records (f.e. via SQL-TOP-Clause or Limit in MySQL or LINQ's Take(3)).

Answer 2

If you can limit the records in your query, then that's the best approach.

However, if you can't limit them in the query... here is another approach:

1. Set "allowpaging=true" and "pagesize=X" (change X to how many rows you want visible).

2. Assign a pagerstyle with a custom CSS class.

   <pagerstyle cssclass="hidden" />

3. Set that custom class to:

   .hidden { visibility: hidden; display: none; }

Now, your grid will use the paging logic, but the pager controls are hidden.

It's not the cleanest/most elegant, but it works.