GridView And PageIndexChangi ng

[phpmel]

Hi Guys,

I have a problem. I have a gridview that is bound to a SQLDataSource using a stored procedure that is used for Searching. it works fine. my problem is that if I select a page index, the grid view disappears.

This is the code for my GridView and datasource

<asp:GridView ID="afGridView" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                        CellPadding="4" DataKeyNames="aID" DataSourceID="findlDataSource" ForeColor="#333333"
                        GridLines="None" OnSelectedIndexChanged="afGridView_SelectedIndexChanged"
                        PageSize="5" Visible="False" EnableViewState="False" OnPageIndexChanging="afGridView_PageIndexChanging">
                        <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                        <Columns>
                            <asp:CommandField SelectText="Update Account" ShowSelectButton="True">
                                <ControlStyle Font-Bold="True" ForeColor="Maroon" />
                            </asp:CommandField>
                            <asp:BoundField DataField="aID" HeaderText="aID" InsertVisible="False" ReadOnly="True"
                                SortExpression="aID" Visible="False" />
                            <asp:BoundField DataField="Account No." HeaderText="Account No." SortExpression="Account No." />
                            <asp:BoundField DataField="Description" HeaderText="Description" SortExpression="Description" />
                            <asp:CheckBoxField DataField="Job No." HeaderText="Job No." SortExpression="Job No." />
                        </Columns>
                        <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
                        <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
                        <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
                        <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                        <AlternatingRowStyle BackColor="White" />
                    </asp:GridView>
                    <asp:SqlDataSource ID="findlDataSource" runat="server" ConnectionString="<%$ ConnectionStrings:DBConnect %>"
                        SelectCommand="FindAccount" SelectCommandType="StoredProcedure" EnableViewState="False">
                        <SelectParameters>
                            <asp:SessionParameter DefaultValue="" Name="all" SessionField="all" Type="String" />
                            <asp:SessionParameter Name="AccountNo" SessionField="AccountNo" Type="Int64" />
                            <asp:SessionParameter Name="description" SessionField="description" Type="String" />
                            <asp:SessionParameter DefaultValue="" Name="jobno" SessionField="jobno" Type="String" />
                        </SelectParameters>
                    </asp:SqlDataSource>
 

This is my c# code to handle the PageindexChangi ng

protected void afGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
       afGridView.PageIndex = e.NewPageIndex;
        afGridView.DataSource = findlDataSource;
    }
 
 

Please Help

[Plater]

You forgot to call the .DataBind() function in your page index changing function.

[phpmel]

If I say this

protected void afGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        afGridView.PageIndex = e.NewPageIndex;
        afGridView.DataSource = findlDataSource;
        afGridView.DataBind();
 
    }

it gives me the following error after i run the application

"Both DataSource and DataSourceID are defined on 'afGridView'. Remove one definition."... .....so that was why i left it out

Any other ideas

[Plater]

Hmm, then you should probably be doing this?

protected void afGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
   afGridView.PageIndex = e.NewPageIndex;
   afGridView.DataBind();
}