DataGrid won't page

[Richard Thomas]

Hi,

I have a DataGrid which is populated by a DataAdapter getting data
from a stored procedure (on SQL Server 2k).

I've set the DataGrid to be pageable, and when I view the page in IE,
the paging controls come up, as does the correct data. However, when I
use the paging controls, it doesn't page to the next data.

I'm guessing that I'll need to change something to do with cursors,
but I'm reasonably new to .net programming, so I was wondering if
anyone could point me in the right direction?

Thanks in advance

Richard

[Joyjit Mukherjee]

Hi,

you need to trap the PageIndexChanged event of the grid and set the
CurrentPageIndex property of the grid as follows: -

private void mygrid_PageIndexChanged(object source,
DataGridPageChangedEventArgs e)
{
mygrid.CurrentPageIndex = e.NewPageIndex;
BindGrid();
}

See the article in
http://msdn.microsoft.com/library/de...lesortable.asp
for more details.

Regards
Joyjit

"Richard Thomas" <ri************@bigfoot.com> wrote in message
news:84**************************@posting.google.c om...

Hi,

I have a DataGrid which is populated by a DataAdapter getting data
from a stored procedure (on SQL Server 2k).

I've set the DataGrid to be pageable, and when I view the page in IE,
the paging controls come up, as does the correct data. However, when I
use the paging controls, it doesn't page to the next data.

I'm guessing that I'll need to change something to do with cursors,
but I'm reasonably new to .net programming, so I was wondering if
anyone could point me in the right direction?

Thanks in advance

Richard