Using what I think of as the Form Designer in Visual Studio.......

I dropped a GridView, TextBox, and Button on the form. The grid uses a DataSource name MySql. The code page shows

Partial Class _Default
    Inherits System.Web.UI.Page
 
   Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.Click
        MySql.SelectCommand = "Select * from test_sched_saves where testresource like '" & TextBox1.Text & "%'"
    End Sub

End Class

Press CTRL-F5 to bring up the window and the grid correctly shows all the data for all testResources.

Enter a letter in the textbox and press the button and grid correctly shows only those testResources beginning with that letter.

So far, so good.

The grid is set to allow pages and at the bottom of the grid is a list of the available pages. When you click on any of those page numbers the grid goes back and displays the entire data set.

Can anybody explain what causes this behavior and what I need to do to prevent regenerating the original dataset when a page number is pressed?

Thanks.............Rich