Multiple datasources in FormView/DetailsView

[swethasivaram]

Hi all

I am displaying some information from my database using DetailsView
which is bound to SqlDataSource1.

<asp:DetailsVie w ID="DetailsView 1" runat="server"
AutoGenerateRow s="False" DataSourceID="S qlDataSource1"
ForeColor="#333 333" >

<asp:SqlDataSou rce ID="SqlDataSour ce1" runat="server"
ConnectionStrin g="<%$ ConnectionStrin gs:ConnectionSt ring %>"
SelectCommand=" SELECT [x], [y], [z], [a], [b], [c] FROM [sometable]
WHERE ([ID] = @ID)"> />

When I allow editing of this information, I want to populate certain
dropdownlists in the DetailsView using different datasources. Is this
possible?

Specifically:

<ItemTemplate >
<asp:Label ID="lbl" runat="server" Text='<%# Bind("someField ")
%>'></asp:Label><br />
</ItemTemplate>

<EditItemTempla te>
<asp:DropDownLi st ID="ddl" runat="server" </asp:DropDownLis t><br />
</EditItemTemplat e>

The ListItems for this DropDownList need to come from another database
table, not the same one to which it is bound in the ItemTemplate.

Is this possible at all?

Thanks!