<form runat="server" class="contactus">
<fieldset>
    <legend>База</legend>
    <asp:GridView ID="sqlData" runat="server" DataSourceID="editDocs" AllowPaging="true"
        PageSize="5" AutoGenerateColumns="false" EnableViewState="false" DataKeyNames="idDoc">
        <%--------------------------- FIELDS -------------------------------%>
        <Columns>
            <asp:BoundField HeaderText="Имя" DataField="name_doc" />
            <asp:BoundField HeaderText="Специальность" DataField="spec_doc" />
            <asp:BoundField DataField="branch_doc" Visible="false" />
            <asp:BoundField DataField="name_br" Visible="false" />
            <asp:BoundField DataField="img_doc" Visible="false"/>
            <asp:BoundField DataField="img_title" Visible="false" />
            <asp:BoundField HeaderText="ИНН" DataField="inn_doc" />
            <asp:TemplateField HeaderText="Фото">
                <ItemTemplate>
                    <asp:Label runat="server" ID="lblID2" Text="1"></asp:Label>
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:DropDownList runat="server" ID="diList" AppendDataBoundItems="true"  DataSourceID="images" DataTextField="img_title"
                        DataValueField="id_img">
                        <asp:ListItem Text="none" Value="null" Selected="False" Enabled="true"></asp:ListItem>
                    </asp:DropDownList>
                </EditItemTemplate>
            </asp:TemplateField>
            <asp:TemplateField HeaderText="Отделение">
                <ItemTemplate>
                    <asp:Label runat="server" ID="lblID" Text="<%#Bind('name_br') %>"></asp:Label>
                </ItemTemplate>
                <EditItemTemplate>
                    <asp:DropDownList runat="server" ID="ddList" DataSourceID="branches" DataTextField="name_br"
                        DataValueField="idBranch" SelectedValue="<%# Bind('branch_doc')%>">
                    </asp:DropDownList>
                </EditItemTemplate>
            </asp:TemplateField>
            <asp:CommandField HeaderText="Редактировать" ShowDeleteButton="true" ShowEditButton="true" />
        </Columns>
        <%-------------------- END FIELDS -----------------------%>
    </asp:GridView>
</fieldset>
<fieldset>
 
    <%--******************* SQL DOCTORS **********************--%>
    <asp:SqlDataSource ID="editDocs" runat="server" ConnectionString="Data Source = .\SQLEXPRESS; Initial catalog = Umbraco; Trusted_connection=true"
        SelectCommand="SELECT name_doc, spec_doc, branch_doc, img_doc, inn_doc, idBranch, name_br FROM Doctors INNER JOIN Branches ON branch_doc=idBranch 
                                            " DeleteCommand="DELETE FROM Doctors WHERE ([idDoc]=@idDoc)"
        UpdateCommand="UPDATE Doctors SET [name_doc]=@name_doc, spec_doc=@spec_doc, [branch_doc]= @branch_doc, img_doc=@img_doc.ToString(), inn_doc=@inn_doc WHERE (idDoc=@idDoc)">
        <DeleteParameters>
            <asp:Parameter Name="idDoc" Type="Int32" />
        </DeleteParameters>
    </asp:SqlDataSource>
    <%---******************* SQL BRANCHES **********************--%>
    <asp:SqlDataSource ID="branches" runat="server" ConnectionString="Data Source = .\SQLEXPRESS; Initial catalog = Umbraco; Trusted_connection=true"
        SelectCommand="SELECT name_br, idBranch from Branches">
        <UpdateParameters>
            <asp:ControlParameter Name="branch_doc" ControlID="ddList" PropertyName="SelectedValue" />
        </UpdateParameters>
    </asp:SqlDataSource>
    <%---******************* SQL IMAGES **********************--%>
    <asp:SqlDataSource ID="images" runat="server" ConnectionString="Data Source = .\SQLEXPRESS; Initial catalog = Umbraco; Trusted_connection=true"
        SelectCommand="SELECT img_title, id_img FROM Images">
        <UpdateParameters>
            <asp:ControlParameter Name="img_doc" ControlID="diList" PropertyName="SelectedValue" />
        </UpdateParameters>
    </asp:SqlDataSource>
    <%----*******************END SQL DATA **********************--%>
</fieldset>
</form>