Data Adapter Binding Help

[BG]

I have a datagrid with paging. Using the following code, it loads data
initially as expected. When I click the next/previous buttons several times,
the table will eventually disappear. It's in the binding but I don't see it.
Any and all suggestions are welcome.

Thanks

G

Sub Page_Load

GetStats(MyIdentity)

End Sub

Sub GetStats(ByVal MyIdentity As String)

Try
Dim Myconnection As New OleDbConnection(connectionstring)
Myconnection.Open()

Dim objSocialAdapter As New OleDbDataAdapter
objSocialAdapter.TableMappings.Add("Table", _SOCIAL)
Dim CmdSocial As OleDbCommand = New OleDbCommand(SQL,
Myconnection)
CmdSocial.CommandType = CommandType.Text
objSocialAdapter.SelectCommand = CmdSocial
objSocialAdapter.Fill(objdset)

Myconnection.Close()

dgSocial.DataSource = objdset.Tables(_SOCIAL)

If Not IsPostBack Then
DataBind()
End If

Catch ex As SystemException

End Try

End Sub

 

[John Saunders]

I have a datagrid with paging. Using the following code, it loads data
initially as expected. When I click the next/previous buttons several
times,
the table will eventually disappear. It's in the binding but I don't see
it.

In the PageChanged and Sort events, you have to reload your data and rebind
it to the DataGrid. Do this after you have changed the new page index.

John Saunders