Replacing TEXTBOX with DROPDOWNLISTBOX in Formview

[mosscliffe]

I have an existing textbox in a formview edit or insert and I wish to
convert it to a DROPDOWNLIST BOX but I can not figure out the syntax
to create the bind that was in the textbox, to how that should be coded
for the DDL

Can anyone please advise

ORIGINAL

<asp:TextBox ID="GenIDTextBox" runat="server" Text='<%# Bind("GenID")
%>'>
</asp:TextBox>

PROPOSED

<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="AccessDataSourceTest"
DataTextField="GenName" DataValueField="GenID">
</asp:DropDownList>

<asp:AccessDataSource ID="AccessDataSourceTest" runat="server"
DataFile="~/App_Data/TreesAll.mdb"
SelectCommand="SELECT [GenName], [GenID] FROM [Genus] ORDER BY
[GenName]">
</asp:AccessDataSource>

[mosscliffe]

Miracles - never cease.

I think I solved it myself, but any comments or advice would be
appreciated

Solution

Add to the DDL definition the following

SelectedValue='<%# Bind("GenID") %>'

so new DDL is

<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="AccessDataSourceTest"
DataTextField="GenName" DataValueField="GenID"
SelectedValue='<%# Bind("GenID") %>' >
</asp:DropDownList>

Tim

[Patrice]

Correct. The current value is Text for the TextBox and SelectedValue for the
drop down.. Seems to make sense to me...

--
Patrice

"mosscliffe" <pa***********@googlemail.com> a écrit dans le message de news:
11**********************@i40g2000cwc.googlegroups. com...

Miracles - never cease.

I think I solved it myself, but any comments or advice would be
appreciated

Solution

Add to the DDL definition the following

SelectedValue='<%# Bind("GenID") %>'

so new DDL is

<asp:DropDownList ID="DropDownList1" runat="server"
DataSourceID="AccessDataSourceTest"
DataTextField="GenName" DataValueField="GenID"
SelectedValue='<%# Bind("GenID") %>' >
</asp:DropDownList>

Tim