You cannot add or change a record because a related record is required in table 'lok"

[André]

Hi,

Still the same (unsolved problem), but other error now.
I have a detailsview for inserting data, and a dropdownlist which
selectedValue must be used to fill one of the field of the detailsview.
Table 'pc' is related to table 'lok'.

I tried a lot of things, but still without succes. Here are the two methods
i tried with two different errors. It works only when i introduce directly a
value in "DefaultVal ue" (see below)

Thanks for any help
André
1) first method:
asp:SqlDataSour ce ID="SqlDataSour ce1" runat="server" ....
....
InsertCommand=" INSERT INTO [pc] ([na], [ty], [lok]) VALUES (?, ?, @lok)"
OldValuesParame terFormatString ="original_{ 0}"
ProviderName="S ystem.Data.OleD b"
<InsertParamete rs>
<asp:Paramete r Name="na" Type="String" />
<asp:Paramete r Name="ty" Type="String" />
</InsertParameter s>
.....
Code-behind:
Protected Sub DropDownList1_S electedIndexCha nged(ByVal sender As Object,
ByVal e As System.EventArg s) Handles DropDownList1.S electedIndexCha nged
lok = DropDownList1.S electedValue
SqlDataSource1. InsertParameter s.Add("lok", lokl)
End Sub

This gives: No value given for one or more required parameters
----------------------------------------------------------------------------
-------------------------
2) second method
asp:SqlDataSour ce ID="SqlDataSour ce1" runat="server" ....
....
InsertCommand=" INSERT INTO [pc] ([na], [ty], [lok]) VALUES (?, ?, @lok)"
OldValuesParame terFormatString ="original_{ 0}"
ProviderName="S ystem.Data.OleD b"
<InsertParamete rs>
<asp:Paramete r Name="na" Type="String" />
<asp:Paramete r Name="ty" Type="String" />
<asp:Paramete r Name="lok" Type="String" DefaultValue="< %=lok %>" />
</InsertParameter s>
....

Code-behind:
Protected Sub DropDownList1_S electedIndexCha nged(ByVal sender As Object,
ByVal e As System.EventArg s) Handles DropDownList1.S electedIndexCha nged
lok = DropDownList1.S electedValue
End Sub

This gives: You cannot add or change a record because a related record is
required in table 'lokl'
which means in fact that the value of the parameter is not passed!

It works when i give directly a value: <asp:Paramete r Name="lok"
Type="String" DefaultValue="1-45" />