i want to create friend list but at a time only 3 records can be display in gridview

Initially set paging to true and page size to 3

(/YourGridViewObject/).AllowPaging=true;
(/YourGridViewObject/).PageSize=3;

On button click set allowpaging to false as

(/YourGridViewObject/).AllowPaging=false;

If you are using Linq then try this
Select rows from dataview using filter in the index[^]
or Dataadapter.Fill method.

First of all you need to do like this...

1) Only 3 Friend will display for this you need to use a query like Mehdi suggested

SELECT TOP 3 * FROM FRIENDLIST

or you can also put ORDER BY Cause at the end of your query.

OR MAKE your own query based on TOP number COLUMN NAME

it will returned only TOP 3 records from your friend list so you can use them to display for it....

2) When user click on Show All Friend Button at that time you need to fire you select Query with out use of TOP NUMBER COLUMN

so it will return all friend from your list, and use them to display for all friend...


like this you can use them...