Værdien fra dropdownliste
Jeg før følgende fejl, når jeg forsøger at indsætte en ny post i en database.- No value given for one or more required parameters.
Tror det skyldes at der ingen værdi kommer med fra min dropdownliste (Type). Men jeg kan bare ikke finde ud af hvorfor. Håber der er nogle der kan hjælpe :-)
<%@ Page Language="VB" MasterPageFile="~/Admin/MasterPage.master" %>
<script runat=server>
Protected Sub DetailsView1_ItemUpdated(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DetailsViewUpdatedEventArgs)
Response.Redirect("sider_ret.aspx?ID=" & Request.QueryString("ID"))
End Sub
Protected Sub DetailsView1_ModeChanging(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.DetailsViewModeEventArgs)
If (e.CancelingEdit = True) Then
Response.Redirect("Indhold.aspx?Show=Sider")
End If
End Sub
</script>
<asp:Content ID="Content1" ContentPlaceHolderID="Indhold" Runat="Server">
<table border="0" cellpadding="2" cellspacing="0">
<tr>
<td><asp:Label Text="Opret sider" runat="server" SkinID="Overskrift"></asp:Label><br /><br /></td>
</tr>
<tr>
<td>
<asp:AccessDataSource id="AccessDataSourceAdmin" Runat="Server"
DataFile = "../App_Data/qualsholm.mdb"
SelectCommand="SELECT * FROM Menu INNER JOIN SIDER ON Menu.ID = Sider.MenuID WHERE ([autoInc] = @autoinc)"
InsertCommand="INSERT INTO Menu ([TopLevelID], [ParentID], [Title], [Sort], [Type]) VALUES (0, 0, @Title, @Sort, @Type)"
>
<SelectParameters>
<asp:QueryStringParameter Name="autoinc" QueryStringField="ID" Type="String" />
</SelectParameters>
</asp:AccessDataSource>
<asp:DetailsView CellPadding="2" DefaultMode="Insert" AutoGenerateRows="False" DataKeyNames="autoinc" GridLines="None"
DataSourceID="AccessDataSourceAdmin" ID="DetailsView1" runat="server"
Width="275px" OnItemUpdated="DetailsView1_ItemUpdated" OnModeChanging="DetailsView1_ModeChanging">
<Fields>
<asp:BoundField DataField="Title" HeaderText="Menu Titel" HeaderStyle-Wrap="false" />
<asp:BoundField DataField="Sort" HeaderText="Placering" HeaderStyle-Wrap="false" />
<asp:TemplateField HeaderText="Type">
<InsertItemTemplate>
<asp:DropDownList ID="Type" DataTextField="Type" runat="server">
<asp:ListItem Value="Text" Text="Text">Tekst</asp:ListItem>
<asp:ListItem Value="PDF" Text="PDF">PDF</asp:ListItem>
</asp:DropDownList>
</InsertItemTemplate>
</asp:TemplateField>
<asp:CommandField ShowInsertButton="True" ButtonType="Image" InsertImageUrl="../App_Images/Gem.gif" CancelImageUrl="../App_Images/Fortryd.gif" ItemStyle-HorizontalAlign="Center" />
</Fields>
</asp:DetailsView>
</td>
</tr>
</table>
</asp:Content>
