Reading all the rows of a datagrid that is using paging...

[Bob Morvay]

This should be simple but I am stuck. I am trying to read all the rows of
my datagrid across all the pages. I can read all the rows on the page that
I am on but I can't seem to figure out how to iterate through all the pages.
Can anyone lend some insight. Here is the basic code that I am using to
attempt to read all the rows...

Private Sub btnUpdate(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles btnUpdate.Click
Dim item As DataGridItem
For Each item In DataGrid1.Items
ID = Convert.ToInt32 (DataGrid1.Data Keys(item.ItemI ndex))
UpdateTable()
Next
End Sub

My example datagrid has 3 pages. This code will only update the database
with the items on the page that I am on when I click the update button. I
need it to iterate through all the pages of the datagrid for all the items.

Thanks in advance.

[Bob Morvay]

I figured it out. I had to set the currentpageinde x of the datagrid, rebind
my data and I can iterate through all the pages via the datagrid pagecount.

"Bob Morvay" <[e-mail]> wrote in message
news:OZ******** ******@TK2MSFTN GP10.phx.gbl...

This should be simple but I am stuck. I am trying to read all the rows of
my datagrid across all the pages. I can read all the rows on the page
that I am on but I can't seem to figure out how to iterate through all the
pages. Can anyone lend some insight. Here is the basic code that I am
using to attempt to read all the rows...

Private Sub btnUpdate(ByVal sender As System.Object, ByVal e As
System.EventArg s) Handles btnUpdate.Click
Dim item As DataGridItem
For Each item In DataGrid1.Items
ID = Convert.ToInt32 (DataGrid1.Data Keys(item.ItemI ndex))
UpdateTable()
Next
End Sub

My example datagrid has 3 pages. This code will only update the database
with the items on the page that I am on when I click the update button. I
need it to iterate through all the pages of the datagrid for all the
items.

Thanks in advance.