Torna al Thread

<FIELDSET style="background-color: #e1fff2"><LEGEND>Allegati</LEGEND> <asp:SqlDataSource id="SqlDataSourceAllegati" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>" DeleteCommand="DELETE FROM [OrdiniAllegati] WHERE [PK_idOrdineAllegato] = @PK_idOrdineAllegato" SelectCommand="SELECT OrdiniAllegati.* FROM OrdiniAllegati WHERE (OrdiniAllegati.FK_idOrdineFornitore = @FK_idOrdineFornitore)" InsertCommand="INSERT INTO OrdiniAllegati(FK_idOrdineFornitore, NomeFile, Descrizione) VALUES (@FK_idOrdineFornitore, @NomeFile, @Descrizione)" UpdateCommand="UPDATE OrdiniAllegati SET NomeFile = @NomeFile, Descrizione = @Descrizione WHERE (PK_idOrdineAllegato = @PK_idOrdineAllegato)"> <DeleteParameters> <asp:Parameter Name="PK_idOrdineAllegato" Type="Int32" /> </DeleteParameters> <SelectParameters> <asp:QueryStringParameter Name="FK_idOrdineFornitore" QueryStringField="id" Type="Int32" /> </SelectParameters> <InsertParameters> <asp:QueryStringParameter Name="FK_idOrdineFornitore" QueryStringField="id" Type="Int32" /> <asp:Parameter Name="NomeFile" /> <asp:Parameter Name="Descrizione" /> </InsertParameters> <UpdateParameters> <asp:Parameter Name="NomeFile" /> <asp:Parameter Name="Descrizione" /> <asp:Parameter Name="PK_idOrdineAllegato" /> </UpdateParameters> </asp:SqlDataSource> <asp:GridView id="GridViewAllegati" runat="server" DataSourceID="SqlDataSourceAllegati" DataKeyNames="PK_idOrdineAllegato" EmptyDataText="Nessuna allegato inserito" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False"> <Columns> <asp:TemplateField ShowHeader="False"> <EditItemTemplate> <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="True" CommandName="Update" Text="Salva" ValidationGroup="GridScadenze"></asp:LinkButton> <asp:LinkButton ID="LinkButton2" runat="server" CausesValidation="False" CommandName="Cancel" Text="Annulla"></asp:LinkButton> </EditItemTemplate> <ItemTemplate> <asp:LinkButton ID="LinkButton1" runat="server" CausesValidation="False" CommandName="Edit" Text="Modifica"></asp:LinkButton> </ItemTemplate> </asp:TemplateField> <asp:BoundField DataField="NomeFile" HeaderText="NomeFile" SortExpression="NomeFile" ReadOnly="True" /> <asp:BoundField DataField="Descrizione" HeaderText="Descrizione" SortExpression="Descrizione" ReadOnly="True" /> <asp:TemplateField HeaderText="Elimina" ShowHeader="False"> <ItemTemplate> <asp:ImageButton ID="ImageButton1" runat="server" CausesValidation="False" CommandName="Delete" ImageUrl="~/images/icon-delete.gif" /> <ajaxToolkit:ConfirmButtonExtender ID="cbe" runat="server" TargetControlID="ImageButton1" ConfirmText="Eliminare la voce?" /> </ItemTemplate> </asp:TemplateField> </Columns> </asp:GridView> <asp:FormView id="FormViewAllegati" runat="server" DataSourceID="SqlDataSourceAllegati" DataKeyNames="PK_idOrdineAllegato" DefaultMode="Insert"> <InsertItemTemplate> <table> <tr> <td> descrizione </td> <td> file </td> </tr> <tr> <td> <asp:TextBox ID="TextBoxDescrizioneAllegato" runat="server"></asp:TextBox> </td> <td> <asp:FileUpload ID="FileUpload1" runat="server" /> </td> </tr> </table> <asp:LinkButton ID="InsertAllegatoButton" runat="server" OnClick="InsertAllegatoButton_Click" Text="Inserisci"></asp:LinkButton> </InsertItemTemplate> </asp:FormView> </FIELDSET>
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5