求助求助！gridview使用accessdatasource查询后分页的问题，

cotton_zym 2016-06-12 11:17:05

我使用gridview显示资源列表，然后资源可按类别查询，如课件、视频等，

然后查询我是通过改变datasource的selectcommand来实现的，当页面加载时，gridview显示所有类型的资源名称，如点击视频按钮后，则显示视频类型的资源，但在分页时，又重新绑定了全部类型的资源，查了好多分页的模板，我也不太会用，试了都不行，急求帮助！

这是前台

<table id="search" width="730px">

    <tr><td width="100px" height="35px"><span style="font-size: 20px">关键词：</span></td>

    <td align="left" width="150px" height="35px"><asp:TextBox ID="TextBox1" runat="server" Height="25px"></asp:TextBox></td>

    <td align="left" height="35px"><asp:ImageButton ID="ImageButton1" runat="server" 

            ImageUrl="img/qb.png" onclick="ImageButton1_Click" /></td></tr>

    <tr><td colspan="3" height="35px"><span>

        <asp:ImageButton ID="ImageButton2" runat="server" ImageUrl="img/kj.png" 

            onclick="ImageButton2_Click" />

        <asp:ImageButton ID="ImageButton3" runat="server" ImageUrl="img/sp.png" 

            onclick="ImageButton3_Click"/>

        <asp:ImageButton ID="ImageButton4" runat="server" ImageUrl="img/wb.png" 

            onclick="ImageButton4_Click" />

        <asp:ImageButton ID="ImageButton5" runat="server" ImageUrl="img/yp.png" 

            onclick="ImageButton5_Click" />

        <asp:ImageButton ID="ImageButton6" runat="server" ImageUrl="img/al.png" 

            onclick="ImageButton6_Click" />

        <asp:ImageButton ID="ImageButton7" runat="server" ImageUrl="img/dh.png" 

            onclick="ImageButton7_Click" />

        </span></td></tr>

    </table>

<table width="730px" id="xiangxi">

    <tr><td>

    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 

            AutoGenerateColumns="False" DataKeyNames="R_NAME" 

            DataSourceID="AccessDataSource1" Width="730px" EmptyDataText="暂无相关资源"

            ShowHeader="false" GridLines="None"

            onrowdatabound="GridView1_RowDataBound" 

            onpageindexchanging="GridView1_PageIndexChanging" PageSize="2">

            

            <Columns>

                <asp:HyperLinkField ControlStyle-CssClass="link" DataTextField="R_NAME" DataNavigateUrlFields="R_ID" DataNavigateUrlFormatString="~/TJ.aspx?R_ID={0}" Target="_blank"  />

                

            </Columns>

        </asp:GridView>

        <asp:AccessDataSource ID="AccessDataSource1" runat="server" 

            DataFile="~/App_Data/jxzygxpt.mdb" SelectCommand="SELECT * FROM [T_RESOURCE] WHERE [R_MAJOR]='信息管理与信息系统' AND [R_STATUS]=-1 order by [R_WEEKHITS] desc">

        </asp:AccessDataSource>

    </td></tr>

    </table>

这是后台

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)

    {

        AccessDataSource1.SelectCommand = "SELECT * FROM [T_RESOURCE] WHERE [R_MAJOR]='信息管理与信息系统' AND [R_STATUS]=-1 AND ([R_KEY] LIKE '%" + TextBox1.Text + "%' OR [R_NAME] LIKE '%" + TextBox1.Text + "%') order by [R_WEEKHITS] desc";

    }

    protected void ImageButton2_Click(object sender, ImageClickEventArgs e)

    {

        AccessDataSource1.SelectCommand = "SELECT * FROM [T_RESOURCE] WHERE [R_MAJOR]='信息管理与信息系统' AND [R_STATUS]=-1 AND [R_TYPE]='课件（PPT）' AND ([R_KEY] LIKE '%" + TextBox1.Text + "%' OR [R_NAME] LIKE '%" + TextBox1.Text + "%') order by [R_WEEKHITS] desc";

    }

    protected void ImageButton3_Click(object sender, ImageClickEventArgs e)

    {

        AccessDataSource1.SelectCommand = "SELECT * FROM [T_RESOURCE] WHERE [R_MAJOR]='信息管理与信息系统' AND [R_STATUS]=-1 AND [R_TYPE]='视频素材' AND ([R_KEY] LIKE '%" + TextBox1.Text + "%' OR [R_NAME] LIKE '%" + TextBox1.Text + "%') order by [R_WEEKHITS] desc";

       

    }

    protected void ImageButton4_Click(object sender, ImageClickEventArgs e)

    {

        AccessDataSource1.SelectCommand = "SELECT * FROM [T_RESOURCE] WHERE [R_MAJOR]='信息管理与信息系统' AND [R_STATUS]=-1 AND [R_TYPE]='文本素材' AND ([R_KEY] LIKE '%" + TextBox1.Text + "%' OR [R_NAME] LIKE '%" + TextBox1.Text + "%') order by [R_WEEKHITS] desc";

    }

    protected void ImageButton5_Click(object sender, ImageClickEventArgs e)

    {

        AccessDataSource1.SelectCommand = "SELECT * FROM [T_RESOURCE] WHERE [R_MAJOR]='信息管理与信息系统' AND [R_STATUS]=-1 AND [R_TYPE]='音频素材' AND ([R_KEY] LIKE '%" + TextBox1.Text + "%' OR [R_NAME] LIKE '%" + TextBox1.Text + "%') order by [R_WEEKHITS] desc";

    }

    protected void ImageButton6_Click(object sender, ImageClickEventArgs e)

    {

        AccessDataSource1.SelectCommand = "SELECT * FROM [T_RESOURCE] WHERE [R_MAJOR]='信息管理与信息系统' AND [R_STATUS]=-1 AND [R_TYPE]='案例' AND ([R_KEY] LIKE '%" + TextBox1.Text + "%' OR [R_NAME] LIKE '%" + TextBox1.Text + "%') order by [R_WEEKHITS] desc";

    }

    protected void ImageButton7_Click(object sender, ImageClickEventArgs e)

    {

        AccessDataSource1.SelectCommand = "SELECT * FROM [T_RESOURCE] WHERE [R_MAJOR]='信息管理与信息系统' AND [R_STATUS]=-1 AND [R_TYPE]='动画素材' AND ([R_KEY] LIKE '%" + TextBox1.Text + "%' OR [R_NAME] LIKE '%" + TextBox1.Text + "%') order by [R_WEEKHITS] desc";

    }

    //public static int flag = 1;



    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

    {

        GridView1.PageIndex = e.NewPageIndex;//获取当前分页的索引值

        GridView1.DataBind();//重新绑定数据

        

    }