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
Expand|Select|Wrap|Line Numbers
- <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>
Expand|Select|Wrap|Line Numbers
- protected void afGridView_PageIndexChanging(object sender, GridViewPageEventArgs e)
- {
- afGridView.PageIndex = e.NewPageIndex;
- afGridView.DataSource = findlDataSource;
- }