<%@ Page Language="C#" Debug="true" ValidateRequest="false" 
AutoEventWireup="true" CodeFile="tootekirjeldused2.aspx.cs" 
Inherits="haldus_tootekirjeldused2" MasterPageFile="~/default.master" %>
<asp:Content ID="c1" runat="server" ContentPlaceHolderID="head">
    <title>Tootekirjelduste leht</title>
</asp:Content>

<asp:Content ID="c2" runat="server" ContentPlaceHolderID="sisu">
 
   
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
            ConnectionString="<%$ ConnectionStrings:veebipoebaasConnectionString %>" 
            DeleteCommand="DELETE FROM [tooted] WHERE [id] = @id" 
            InsertCommand="INSERT INTO [tooted] ([pildiDATA], [pildiURL], [koguslaos], [hind], [nimetus]) VALUES (@pildiDATA, @pildiURL, @koguslaos, @hind, @nimetus)" 
            SelectCommand="SELECT [pildiDATA], [pildiURL], [koguslaos], [hind], [id], [nimetus] FROM [tooted]" 
            UpdateCommand="UPDATE [tooted] SET [pildiDATA] = @pildiDATA, [pildiURL] = @pildiURL, [koguslaos] = @koguslaos, [hind] = @hind, [nimetus] = @nimetus WHERE [id] = @id">
        <DeleteParameters>
            <asp:Parameter Name="id" Type="Int32" />
        </DeleteParameters>
        <UpdateParameters>
            <asp:Parameter Name="pildiDATA"  />
            <asp:Parameter Name="pildiURL" Type="String" />
            <asp:Parameter Name="koguslaos" Type="Int32" />
            <asp:Parameter Name="hind" Type="Decimal" />
            <asp:Parameter Name="nimetus" Type="String" />
            <asp:Parameter Name="id" Type="Int32" />
        </UpdateParameters>
        <InsertParameters>
            <asp:Parameter Name="pildiDATA"  />
            <asp:Parameter Name="pildiURL" Type="String" />
            <asp:Parameter Name="koguslaos" Type="Int32" />
            <asp:Parameter Name="hind" Type="Decimal" />
            <asp:Parameter Name="nimetus" Type="String" />
        </InsertParameters>
        </asp:SqlDataSource>
    
    <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" 
        DataKeyNames="id" DataSourceID="SqlDataSource1" DefaultMode="Insert"  >
        <Fields>
            <asp:BoundField DataField="pildiURL" HeaderText="pildiURL" 
                SortExpression="pildiURL" />
            <asp:BoundField DataField="koguslaos" HeaderText="koguslaos" 
                SortExpression="koguslaos" />
            <asp:BoundField DataField="hind" HeaderText="hind" SortExpression="hind" />
            <asp:BoundField DataField="id" HeaderText="id" InsertVisible="False" 
                ReadOnly="True" SortExpression="id" />
            <asp:BoundField DataField="nimetus" HeaderText="nimetus" 
                SortExpression="nimetus" />
            <asp:TemplateField HeaderText="Pildifail">
              <InsertItemTemplate>
                  <asp:FileUpload ID="FileUpload1" runat="server"
                    FileBytes='<%# Bind("pildiDATA") %>'  />
              </InsertItemTemplate>
            </asp:TemplateField>
            <asp:CommandField ShowInsertButton="True" />
        </Fields>
    </asp:DetailsView>
</asp:Content>