Opdatere en post fra formview
Er der nogen der kan se hvorfor nedenstående ikke opdatere posten i databasen? Jeg syntes ellers jeg har fuldt eksemplet fra microsoft asp.net side men det virke ikke..<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" Title="Untitled Page" %>
<%@ Register TagPrefix="ICDropDownList" TagName="Lande" Src="App_Controls/DropDownlist_Lande.ascx" %>
<%@ Register TagPrefix="ICDropDownList" TagName="Segment" Src="App_Controls/DropDownlist_Segment.ascx" %>
<script runat="server">
Sub EmployeeFormView_ItemUpdated(ByVal sender As Object, ByVal e As FormViewUpdatedEventArgs)
FormView1.DataBind()
End Sub
</script>
<asp:Content ID="Content1" ContentPlaceHolderID="Indhold" Runat="Server">
<asp:FormView ID="FormView1" OnItemUpdated="EmployeeFormView_ItemUpdated" DefaultMode="Edit" runat="server" DataSourceID="AccessDataSourceICData2b" DataKeyNames="AutoInc">
<EditItemTemplate>
<table width="700" border="0" cellpadding="0" cellspacing="0" bgcolor="#EFEFEF">
<tr>
<td>
<table border="0" cellpadding="1" cellspacing="0">
<tr>
<td><asp:Label ID="lFirmanavn" runat="server" Text="Firmanavn" /></td>
<td><asp:TextBox Text='<%# Bind("Firmanavn") %>' runat="server" Width="200px" ID="tbFirmanavn" /></td>
</tr>
<tr>
<td><asp:Label ID="lAdresse" runat="server" Text="Adresse" /></td>
<td><asp:TextBox Text='<%# Bind("Adresse") %>' runat="server" Width="200px" ID="tbAdresse" /></td>
</tr>
<tr>
<td><asp:Label ID="lPostnummer" runat="server" Text="Postnummer" /></td>
<td><asp:TextBox Text='<%# Bind("Postnummer") %>' runat="server" Width="50px" ID="tbPostnummer" /></td>
</tr>
<tr>
<td><asp:Label ID="lBy" runat="server" Text="By" /></td>
<td><asp:TextBox Text='<%# Bind("By") %>' runat="server" Width="200px" ID="tbBy" /></td>
</tr>
<tr>
<td><asp:Label ID="lLandekode" runat="server" Text="Landekode" /></td>
<td><ICDropDownList:Lande selValue='<%# Bind("Landekode") %>' id="ddlLandekode" runat="Server"/></td>
</tr>
<tr>
<td><asp:Label ID="lTelefon" runat="server" Text="Telefon" /></td>
<td><asp:TextBox Text='<%# Bind("Telefonnummer") %>' runat="server" Width="200px" ID="tbTelefon" /></td>
</tr>
<tr>
<td><asp:Label ID="lFax" runat="server" Text="Fax" /></td>
<td><asp:TextBox Text='<%# Bind("Faxnummer") %>' runat="server" Width="200px" ID="tbFax" /></td>
</tr>
<tr>
<td><asp:Label ID="lWWW" runat="server" Text="WWW" /></td>
<td><asp:TextBox Text='<%# Bind("wwwadresse") %>' runat="server" Width="200px" ID="tbWWW" /></td>
</tr>
<tr>
<td><asp:Label ID="lDomain" runat="server" Text="Domæne" /></td>
<td><asp:TextBox Text='<%# Bind("Domæne") %>' runat="server" Width="200px" ID="tbDomæne" /></td>
</tr>
<tr>
<td><asp:Label ID="lEmail" runat="server" Text="Email" /></td>
<td><asp:TextBox Text='<%# Bind("[E-mail]") %>' runat="server" Width="200px" ID="tbEmail" /></td>
</tr>
<tr>
<td><asp:Label ID="lSegment" runat="server" Text="Segment" /></td>
<td><ICDropDownList:Segment selValue='<%# Bind("Segmenteringskode") %>' id="Lande1" runat="Server"/></td>
</tr>
</table>
</td>
<td></td>
<td></td>
</tr>
</table>
<asp:LinkButton ID="UpdateButton"
Text="Update"
CommandName="Update"
RunAt="server"/>
<asp:LinkButton ID="CancelUpdateButton"
Text="Cancel"
CommandName="Cancel"
RunAt="server"/>
</EditItemTemplate>
</asp:FormView>
<asp:AccessDataSource id="AccessDataSourceICData2b" Runat="Server" UpdateCommandType = "Text"
DataFile = "App_Data/icsystem.mdb"
SelectCommand = "SELECT * FROM ICD WHERE AutoInc=@autoInc"
UpdateCommand = "Update [ICD] Set
[Firmanavn]=@Firmanavn,
[Adresse]=@Adresse,
[Postnummer]=@Postnummer,
[By]=@By,
[Landekode]=@Landekode,
[Telefonnummer]=@Telefon,
[Faxnummer]=@Fax,
[WWWadresse]=@WWW,
[Domæne]=@Domæne,
[E-mail]=@Email,
[Segmenteringskode]=@Segment
Where [AutoInc]=@AutoInc"
>
<SelectParameters>
<asp:QueryStringParameter Name="autoInc" QueryStringField="ID" Type="String" />
</SelectParameters>
<UpdateParameters>
<asp:Parameter Name="autoInc" Type="string" />
<asp:Parameter Name="Firmanavn" Type="string" />
<asp:Parameter Name="Adresse" Type="string" />
<asp:Parameter Name="Postnummer" Type="string" />
<asp:Parameter Name="By" Type="string" />
<asp:Parameter Name="Landekode" Type="Int16" />
<asp:Parameter Name="Telefon" Type="string" />
<asp:Parameter Name="Fax" Type="string" />
<asp:Parameter Name="WWW" Type="string" />
<asp:Parameter Name="Domæne" Type="string" />
<asp:Parameter Name="Email" Type="string" />
<asp:Parameter Name="Segment" Type="Int16" />
</UpdateParameters>
</asp:AccessDataSource>
</asp:Content>
