<asp:Repeater ID="Repeater1" runat="server" DataSourceID="SqlDataSource1"> <itemtemplate> <asp:HiddenField ID="HiddenField1" runat="server" Value='<%# Eval("GroupID")%>' /> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:testConnectionString %>" SelectCommandType="StoredProcedure" SelectCommand="kbiReport" FilterExpression="[Division] like '{0}%' and [Organization] like '{1}%'"> <SelectParameters> <%--ControlParameter is linked to the HiddenField above to generate different GridView based on different values of GroupID--%> <asp:ControlParameter ControlID="HiddenField1" Name="GroupID" PropertyName="Value" /> </SelectParameters> <asp:GridView ID="GridView1" runat="server" AllowSorting="True" CellPadding="3" DataSourceID="SqlDataSource1" CssClass="mGrid" AlternatingRowStyle-CssClass="alt" RowStyle-HorizontalAlign="Center"> <alternatingrowstyle backcolor="White" forecolor="#284775" /> <columns> <asp:CommandField ShowSelectButton="True" /> </columns> </itemtemplate> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:testConnectionString %>" SelectCommand="SELECT DISTINCT GroupID FROM courses">
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)