How bind Listbox or DropDownlist

[Patrik Zdarsa]

Hi,
I'm try VS 2005 and need UPDATE database record in viewform, all working
when every filed is type TextBox (html INPUT) but I need change one TextBox
to Listbox or dropdownlist and read data from another table and store it in
table1 in parameter "stav". Load data to ListBox is not problem but when I
try update record there is error "stav is null", is any way how to bind
listbox or dropdownlist.

Code:
<UpdateParameters>
<asparameter Name="puvod" Type="String" />
<asparameter Name="stav" Type="String" />
</UpdateParameters>

<asp:TextBox ID="puvodTextBox" runat="server" Text='<%# Bind("puvod")
%>'></asp:TextBox><br />
<asp:dropdownlist ID="stavListbox" runat="server"
DataSourceID="SqlDataSource2" DataTextField="rolename"
DataValueField="rolename"></asp:dropdownlist>

thank you
Patrik

 

[RCS]

The easiest way is to use the wizard to do this, but from the code below,
the only thing you are missing is, you need to bind the dropdownlist
selectedvalue to your Update command. So make this change:

<asp:dropdownlist ID="stavListbox" runat="server"
DataSourceID="SqlDataSource2" DataTextField="rolename"
DataValueField="rolename"
SelectedValue='<%#Bind("stav")%>'></asp:dropdownlist>

This isn't tested, but I believe that should work.. HTH