How to show 10 next records on DataGrid ?

[whale84]

I let DataGrid show 10 items each time loading.When I click the lastest item in those 10 items , DataGrid will be databinded with 10 next items in my database.But I don't know how to do it ! Help me please .Thanks a lot.

[Plater]

DataGrid or DataGridView? (or GridView?)
If you have a DataSet with all your data, you can keep track of the row index you are at keep making smaller DataSet's that only have collections of 10 rows in them?

[whale84]

DataGrid or DataGridView? (or GridView?)
If you have a DataSet with all your data, you can keep track of the row index you are at keep making smaller DataSet's that only have collections of 10 rows in them?

I use DataGrid of VS 2003.I have already done a store procedure to databind DataGrid with it.It like below :

CREATE PROCEDURE Test8
@count int
AS
declare @sql nvarchar(255)
set @sql= 'select top 10 * from tblBaiHat where LuotNghe not in (select top ' + cast(@count as varchar(50)) + ' LuotNghe from tblBaiHat order by LuotNghe desc) order by LuotNghe desc'
execute(@sql)
GO

I am going to make a DataSet with this store procedure. @count is set to 10,20,30....to get 10 rows each time.
This store procedure is only get 10 rows each time to databind for DataGrid.But how can I resolve the event of click on the lastest item of DataGrid to databind 10 next rows for DataGrid ?