<asp:SqlDataSource ID="SqlDataSourceEditore" runat="server" 
        ConnectionString="<%$ ConnectionStrings:catalogo_unicoConnectionString2 %>" 
        SelectCommand="SELECT DISTINCT [editore] FROM [Catalogo]">
    </asp:SqlDataSource>
    
    <asp:SqlDataSource ID="SqlDataSourceGenere" runat="server" 
        ConnectionString="<%$ ConnectionStrings:catalogo_unicoConnectionString2 %>" 
        SelectCommand="SELECT DISTINCT [genere] FROM [Catalogo] WHERE [editore] = @editore_parameter">
        
        <SelectParameters>
            <asp:ControlParameter name="editore_parameter" controlid="DropDownList1" propertyname="SelectedValue"/>
        </SelectParameters>
        
    </asp:SqlDataSource>
    
    <asp:SqlDataSource ID="SqlDataSourceTitolo" runat="server" 
        ConnectionString="<%$ ConnectionStrings:catalogo_unicoConnectionString2 %>" 
        SelectCommand="SELECT DISTINCT [titolo] FROM [Catalogo] WHERE [editore] = @editore_parameter AND [genere] = @genere_parameter">
    
    <SelectParameters>
        <asp:ControlParameter name="editore_parameter" controlid="DropDownList1" propertyname="SelectedValue"/>
        <asp:ControlParameter name="genere_parameter" controlid="DropDownList2" propertyname="SelectedValue"/>
    </SelectParameters>
    
    </asp:SqlDataSource>
    
    <asp:SqlDataSource ID="SqlDataSourceISBN" runat="server" 
            ConnectionString="<%$ ConnectionStrings:catalogo_unicoConnectionString %>" 
            SelectCommand="SELECT [ISBN] FROM [Catalogo] WHERE [editore] = @editore_parameter AND [genere] = @genere_parameter AND [titolo] = @titolo_parameter">
    
    <SelectParameters>
        <asp:ControlParameter name="editore_parameter" controlid="DropDownList1" propertyname="SelectedValue"/>
        <asp:ControlParameter name="genere_parameter" controlid="DropDownList2" propertyname="SelectedValue"/>
        <asp:ControlParameter name="titolo_parameter" controlid="DropDownList3" propertyname="SelectedValue"/>
    </SelectParameters>
    
    </asp:SqlDataSource>
    
    <asp:SqlDataSource ID="SqlDataSourceRecensioneIN" runat="server" 
        ConnectionString="<%$ ConnectionStrings:catalogo_unicoConnectionString2 %>" 
        InsertCommand="INSERT INTO [Recensioni] ([Utente], [Opinione], [Contenuto], [Ebook], [data]) VALUES (@userName, @opinione, @contenuto, @ebook, getdate())">
    
    <InsertParameters>
        <asp:ControlParameter ControlID="hidNomeUtente" DefaultValue="" Name="userName" PropertyName="Value" /> 
        <asp:ControlParameter ControlID="TextOpinione" Name="opinione" Type="String" />
        <asp:ControlParameter ControlID="TextContenuto" Name="contenuto" Type="String" />
        <asp:ControlParameter ControlID="DropDownListEbook" Name="ebook" Type="String" />   
    </InsertParameters>
    
    </asp:SqlDataSource>
   
    <asp:SqlDataSource ID="SqlDataSourceRecensioneOUT" runat="server" 
        ConnectionString="<%$ ConnectionStrings:catalogo_unicoConnectionString2 %>" 
        SelectCommand="SELECT * FROM [Recensioni]">
    </asp:SqlDataSource>
    
    Editore:<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" 
        DataSourceID="SqlDataSourceEditore" DataTextField="editore" 
        DataValueField="editore">
    </asp:DropDownList>
&nbsp;
    <br />
    Genere:<asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True" 
        DataSourceID="SqlDataSourceGenere" DataTextField="genere" 
        DataValueField="genere">
    </asp:DropDownList>
&nbsp; 
    <br />
    Titolo:&nbsp;
    <asp:DropDownList ID="DropDownList3" runat="server" AutoPostBack="True" 
        DataSourceID="SqlDataSourceTitolo" DataTextField="titolo" 
        DataValueField="titolo">
    </asp:DropDownList>
&nbsp; 
    <br />
    ISBN:&nbsp;&nbsp;
  
    <asp:DropDownList ID="DropDownListEbook" runat="server" AutoPostBack="True" 
        DataSourceID="SqlDataSourceISBN" DataTextField="ISBN" 
        DataValueField="ISBN">
    </asp:DropDownList>