How to prevent error in datagrid

[Guest]

Hi all,
I have problem in auto scroll to previous page when i try to delete the last
row of the datagrid.

The problem scenario is:
1.I click on next page of the datagrid.
2.I delete all the data in the page.
3.When i try to delete the last row, the error happen.

The error message:
Invalid CurrentPageIndex value. It must be >= 0 and < the PageCount.

The code that cause the error is at datagrid.databind()
How to solve it??

Any ideas?
thank you in advance.
Best regards,
Gin Lye Khor

 

[Guest]

Hi Gin,

Keep a counter of the number of rows deleted (iNoOfRecordsDeleted). If you
delete a page then the no. of deleted rows is the DataGrid.PageSize. Then
before you rebind the grid, check for the CurrentPageIndex:

If iNoOfRecordsDeleted = datagrid1.PageSize AndAlso _
datagrid1.CurrentPageIndex = datagrid1.PageCount - 1 Then
datagrid1.CurrentPageIndex -= 1
End If