Datagrid Paging Question

[kleptos]

If i have a datagrid and want to implement paging, i can do it and it shows correctly on the rendered web page. But if i click on the numbers to go to the next page, i get a page not found, i am assuming i have to add the code to go to the next set of records, and ideas how to do that? In C#?

[Cander]

example..in VB..sorry but ahould be simple to convert to c#


<asp:DataGrid id="gridCorpList" runat="server" AllowPaging="True" OnPageIndexChanged="gridCorpList_Page" Width="100%" PageSize="5" ShowHeader="False" GridLines="None">
<PagerStyle mode="NumericPages"></PagerStyle>
</asp:DataGrid>



Sub gridCorpList_Page(source As Object, e As DataGridPageChangedEventArgs)
gridCorpList.CurrentPageIndex = e.NewPageIndex
strSQL= "Select Corp_Name FROM Corporations Where id <> 1 ORDER BY Corp_Name"
myConn = New OleDbConnection (strConnString)
' Populate the Dataset from the SQL statement
' Run the Sql statement and get the Data into the DataAdapter
myCommand = New OleDbDataAdapter(strSQL, myConn)
' Fill the DataSet and name the table
myCommand.Fill(myDS, "Corp")
myConn.Close()

gridCorpList.DataSource = myDS.Tables("Corp").DefaultView
gridCorpList.DataBind()
End Sub

[kleptos]

Thanks!