Hi,
I have a detailsview with two fields: in editmode, one is a textbox and the
other is a dropdownlist.
i want to update both fields using the detailsview.
My problem: when clicking on the edit button, the modified text in the
textbox is effectively updated in the table, but instead of updating the
chosen value of the dropdownlist, the field in the table becomes empty (old
value is updated by nothing).
The items of the dropdownlist comes from table ("fotos"), but the
selectedvalue comes from table("inhoud").
In editmode, i can see all the items of the dropdownlist and the
selectedvalue is also right.
Protected Sub DetailsView1_DataBound(ByVal sender As Object, ByVal e As
System.EventArgs) Handles DetailsView1.DataBound
Dim sql, foto, fotosel As String
Dim comd As SqlCommand
Dim dtreader As SqlDataReader
Dim dd1 As DropDownList
Dim z1 As ListItem
' i read here the value which must be the selectedvalue of the
dropdownlist
Using mConnection As New SqlConnection(param.ConnectionString)
sql = "select foto_n1 from inhoud"
comd = New SqlCommand(sql, mConnection)
mConnection.Open()
dtreader = comd.ExecuteReader
dtreader.Read()
If Not dtreader.IsDBNull(0) Then fotosel = dtreader.GetString(0)
dtreader.Close()
'i read here all the possible items of the dropdownlist and put
them in the DD
sql = "select foto_na from fotos"
comd = New SqlCommand(sql, mConnection)
dtreader = comd.ExecuteReader
If dtreader.HasRows Then
While dtreader.Read()
foto = dtreader.GetString(0)
If DetailsView1.CurrentMode = DetailsViewMode.Edit Then
dd1 = DetailsView1.Rows(1).FindControl("dd1")
z1 = New ListItem(foto, foto)
dd1.Items.Add(z1)
dd1.SelectedValue = fotosel
End If
End While
End If
dtreader.Close()
End Using
End Sub
aspx:
----
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:myconn %>"
SelectCommand="SELECT * FROM [inhoud]"
UpdateCommand="UPDATE [inhoud] SET [foto_n1] = @foto_n1, [n1] =
@n1 WHERE [id] = @id">
<UpdateParameters>
<asp:Parameter Name="foto_n1" Type="String" />
<asp:Parameter Name="n1" Type="String" />
<asp:Parameter Name="id" Type="Int32" />
</UpdateParameters>
</asp:SqlDataSource>
<asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True"
AutoGenerateEditButton="True" AutoGenerateRows="False" DataKeyNames="id"
DataSourceID="SqlDataSource1" >
<Fields>
<asp:BoundField DataField="id" HeaderText="id"
InsertVisible="False"
ReadOnly="True" Visible="false" SortExpression="id" />
<asp:TemplateField HeaderText="foto niveau 1">
<ItemTemplate>
<asp:Label ID="Label2" runat="server" Text='<%#
Bind("foto_n1") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:DropDownList ID="dd1" runat="server"
Width="155px">
</asp:DropDownList>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="niveau 1">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("n1")
%>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox1" TextMode="MultiLine"
height="340px" runat="server" Text='<%# Bind("n1") %>'
Width="600px"></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
</Fields>
</asp:DetailsView>
