<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="CustomerID"
        DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None" Width="100%">
        <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
        <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
        <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
        <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
        <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
        <AlternatingRowStyle BackColor="White" />
        <Columns>
            <asp:BoundField DataField="CustomerID" HeaderText="№" InsertVisible="False" ReadOnly="True"
                SortExpression="CustomerID" />
            <asp:TemplateField HeaderText="Организация" SortExpression="CustomerName">
                <EditItemTemplate>
                    <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("CustomerName") %>'></asp:TextBox>
                </EditItemTemplate>
                <ItemTemplate>
                   <a href='AddCostumer.aspx?CustomerID=<%# DataBinder.Eval(Container.DataItem, "CustomerID")%>'> <asp:Label ID="Label1" runat="server" Text='<%# Bind("CustomerName") %>'></asp:Label></a>
                </ItemTemplate>
            </asp:TemplateField>
            <asp:BoundField DataField="ServiceDirectoryName" HeaderText="Предлагаемая продукция и услуги"
                SortExpression="ServiceDirectoryName" />
            <asp:TemplateField>
                <ItemTemplate>
                    <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataTender">
                        <Columns>
                            <asp:BoundField DataField="Expr1" HeaderText="Expr1" SortExpression="Expr1" />
                        </Columns>
                    </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataTender" runat="server" ConnectionString="<%$ ConnectionStrings:finishConnectionString %>"
                        SelectCommand="SELECT COUNT(TenderID) AS Expr1 FROM Tenders WHERE (CustomerID = @CustomerID)">
                        <SelectParameters>
                            <asp:ControlParameter ControlID="GridView1" Name="CustomerID" PropertyName="SelectedValue" />
                        </SelectParameters>
                    </asp:SqlDataSource>
                </ItemTemplate>
            </asp:TemplateField>
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:finishConnectionString %>"
        SelectCommand="SELECT Customers.CustomerID, Customers.CustomerName, ServiceDirectory.ServiceDirectoryName FROM Customers INNER JOIN ServiceDirectory ON Customers.ServiceDirectoryID = ServiceDirectory.ServiceDirectoryID">
    </asp:SqlDataSource>