动态变化sqldataSource.commandText后，分页无效

[znmbc2013]

前台

    <form id="form1" runat="server">


     <asp:TextBox ID="txtFilter" runat="server"></asp:TextBox>
      <asp:Button ID="btnSearch" runat="server" Text="搜索" />
      <asp:gridview id="grvTest"  DataSourceID="sqlDataSource1"
        autogeneratecolumns="true"
        emptydatatext="No data available." 
       
        allowpaging="True" 
        runat="server" >

        <pagersettings mode="Numeric"
          position="Bottom"           
          pagebuttoncount="10"/>
      </asp:gridview>
      <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
          ConnectionString="<%$ ConnectionStrings:xxxx %>" 
          SelectCommand="select [id],[name],[age] from employee">

      </asp:SqlDataSource>


    </form>

后台

    Protected Sub btnSearch_Click(sender As Object, e As EventArgs) Handles btnSearch.Click
        sqlDataSource1.selectCommand= "select [id],[name],[age] from employee where [name] like '%" & txtFilter.Text & "%'"
    End Sub

一个员工页面，gridview显示id，姓名，年龄。
我点击搜索，可以模糊过滤出员工姓名。
但是分页功能不正常，显示出的还是前台里设置的selectCommand="select [id],[name],[age] from employee"

[snlixing]

Protected Sub btnSearch_Click(sender As Object, e As EventArgs) Handles btnSearch.Click sqlDataSource1.selectCommand= "select [id],[name],[age] from employee where [name] like '%" & txtFilter.Text & "%'"; grvTest.DataBind(); End Sub 重新绑定一下看看