ecco il codice
codice:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default2.aspx.cs" Inherits="Default2" %>
<%@ Register assembly="System.Web.Entity, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" namespace="System.Web.UI.WebControls" tagprefix="asp" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title> </head>
<body>
<form id="form1" runat="server">
<div> <asp:DetailsView ID="DetailsView1" runat="server" Height="50px" Width="125px" AutoGenerateRows="False" DataKeyNames="articoliID" DataSourceID="EDSArticoli" DefaultMode="Insert">
<Fields> <asp:BoundField DataField="articoliID" HeaderText="articoliID" ReadOnly="True" SortExpression="articoliID" Visible="False" />
<asp:BoundField DataField="codice" HeaderText="codice" SortExpression="codice" />
<asp:BoundField DataField="articoliDescrizione" HeaderText="articoliDescrizione" SortExpression="articoliDescrizione" />
<asp:TemplateField HeaderText="fornitori.fornitoriID" SortExpression="fornitori.fornitoriID" ConvertEmptyStringToNull="true">
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("[fornitori.fornitoriID]") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="EDSfornitori" DataTextField="fornitoriNome" DataValueField="fornitoriID" SelectedValue='<%# Bind("fornitori.fornitoriNome") %>'>
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("[fornitori.fornitoriID]") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="marche.marcheID" SortExpression="marche.marcheID" ConvertEmptyStringToNull="true"> <EditItemTemplate>
<asp:TextBox ID="TextBox2" runat="server" Text='<%# Bind("[marche.marcheID]") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="EDSmarche" DataTextField="marcheNome" DataValueField="marcheID"
SelectedValue='<%# Bind("marche.marcheID") %>'>
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%# Bind("[marche.marcheID]") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="modelli.modelliID" SortExpression="modelli.modelliID" ConvertEmptyStringToNull="true">
<EditItemTemplate>
<asp:TextBox ID="TextBox3" runat="server" Text='<%# Bind("[modelli.modelliID]") %>'></asp:TextBox>
</EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="DropDownList3" runat="server" DataSourceID="EDSmodelli" DataTextField="modelliNome" DataValueField="modelliID" SelectedValue='<%# Bind("modelli.modelliID") %>'>
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label3" runat="server" Text='<%# Bind("[modelli.modelliID]") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="tipologie.tipologieID" SortExpression="tipologie.tipologieID" ConvertEmptyStringToNull="true"> <EditItemTemplate>
<asp:TextBox ID="TextBox4" runat="server" Text='<%# Bind("[tipologie.tipologieID]") %>'></asp:TextBox> </EditItemTemplate>
<InsertItemTemplate>
<asp:DropDownList ID="DropDownList4" runat="server" DataSourceID="EDSTipologie" DataTextField="tipologieNome" DataValueField="tipologieID" SelectedValue='<%# Bind("tipologie.tipologieID") %>'>
</asp:DropDownList>
</InsertItemTemplate>
<ItemTemplate>
<asp:Label ID="Label4" runat="server" Text='<%# Bind("[tipologie.tipologieID]") %>'></asp:Label>
</ItemTemplate>
</asp:TemplateField>
<asp:CommandField ButtonType="Button" ShowInsertButton="True" /> </Fields>
</asp:DetailsView>
<asp:EntityDataSource ID="EDSfornitori" runat="server" ConnectionString="name=dbmagaEntities" DefaultContainerName="dbmagaEntities" EntitySetName="fornitori" Select="it.[fornitoriID], it.[fornitoriNome]">
</asp:EntityDataSource>
<asp:EntityDataSource ID="EDSmarche" runat="server" ConnectionString="name=dbmagaEntities" DefaultContainerName="dbmagaEntities" EntitySetName="marche">
</asp:EntityDataSource>
<asp:EntityDataSource ID="EDSmodelli" runat="server" ConnectionString="name=dbmagaEntities" DefaultContainerName="dbmagaEntities" EntitySetName="modelli">
</asp:EntityDataSource>
<asp:EntityDataSource ID="EDSTipologie" runat="server" ConnectionString="name=dbmagaEntities" DefaultContainerName="dbmagaEntities" EntitySetName="tipologie">
</asp:EntityDataSource>
</div>
<asp:EntityDataSource ID="EDSArticoli" runat="server" ConnectionString="name=dbmagaEntities" DefaultContainerName="dbmagaEntities" EnableDelete="True" EnableInsert="True" EnableUpdate="True" EntitySetName="articoli" Include="fornitori, marche, modelli, tipologie" AutoGenerateWhereClause="True">
</asp:EntityDataSource>
</form>
</body>
</html>