使用查询绑定下拉列表中的两组数据 [英] Binding two sets of data from a dropdownlist with a query

问题描述

所以，基本上我要做的是从下拉列表中获取两个不同的值，这些值使用数据源并在详细信息视图中，然后我需要绑定该数据并在控件参数中使用它。我需要'movietitle'和'movieid'。我完全难过了，而且不知道怎么做。你能给我的任何提示都会很棒。 







代码： 

So, basically what i'm trying to do is get two different values from a dropdownlist that uses a datasource and is inside a detailsview and then I need to bind that data and use it in controlparameters. I need both 'movietitle' and 'movieid'. I'm completely stumped and this and have like no idea how to do it. Any tips you could offer me would be amazing. 



Code: 

<pre lang="c#">
<asp:DetailsView ID="CustomerDetail" 
DataSourceID="moviedatasource" AutoGenerateRows="false"
AutoGenerateInsertButton="true" 
AutoGenerateEditButton="true" 
AutoGenerateDeleteButton="true"
EmptyDataText="No records." 
DataKeyNames="username" GridLines="Both" 
OnItemInserted="CustomerDetail_ItemInserted"
OnItemInserting="CustomerDetail_ItemInserting" 
OnItemUpdated="CustomerDetail_ItemUpdated"
OnItemUpdating="CustomerDetail_ItemUpdating" 
OnItemDeleted="CustomerDetail_ItemDeleted"
runat="server">
<HeaderStyle BackColor="Navy" ForeColor="White" />
<RowStyle BackColor="White" />
<AlternatingRowStyle BackColor="LightGray" />
<EditRowStyle BackColor="LightCyan" />
<Fields>
<asp:BoundField DataField="UserName" Visible="False" HeaderText="username" InsertVisible="false" ReadOnly="true" SortExpression="username" />
<asp:TemplateField HeaderText="MovieTitle" SortExpression="Movieid">
<ItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSourceW2" DataTextField="movieTitle" DataValueField="MovieId" SelectedValue='<%#Bind("movieID")%>' ></asp:DropDownList>
<asp:SqlDataSource ID="SqlDataSourceW2" runat="server" ConnectionString="<%$ ConnectionStrings:Database1ConnectionString %>" 
ProviderName="<%$ ConnectionStrings:Database1ConnectionString.ProviderName %>" 
SelectCommand="SELECT [MovieID], [MovieTitle] FROM [movies_table] ORDER BY [Movietitle], [MovieID]"></asp:SqlDataSource>
</ItemTemplate> 
</asp:TemplateField>
<asp:BoundField DataField="MovieTitle" HeaderText="MovieTitle" />
<asp:BoundField DataField="MovieID" HeaderText="MovieID" />
<asp:BoundField DataField="Rating" HeaderText="Rating" />
<asp:BoundField DataField="Review" HeaderText="Review" />
</Fields>
</asp:DetailsView>



<asp:SqlDataSource ID="moviedatasource" 
ConnectionString=
"<%$ ConnectionStrings:Database1ConnectionString %>"
ProviderName="<%$ ConnectionStrings:Database1ConnectionString.ProviderName %>"
runat="server" 
SelectCommand="SELECT * FROM [review_table] 
WHERE ([UserName] = @UserName)"
DeleteCommand="DELETE FROM [review_table] 
WHERE [UserName] = @UserName"
InsertCommand="INSERT INTO [review_table] ([UserName], 
[movieid], [movietitle], [rating], [review]) 
VALUES (@UserName, @movieid, @movietitle, @rating, 
@review)"
UpdateCommand="UPDATE [review_table] SET [rating] = @rating, 
[review] = @review
WHERE [UserName] = @UserName AND [Movieid] = @Title">
<SelectParameters>
<asp:SessionParameter Name="UserName" SessionField="UserName" Type="String" DefaultValue="VaderRox" />
<asp:ControlParameter ControlID="CustomerDetail$DropDownList1" Name="Title" PropertyName="SelectedValue" />

</SelectParameters>
<DeleteParameters>
<asp:SessionParameter Name="UserName" SessionField="UserName" Type="String" DefaultValue="VaderRox" />
</DeleteParameters>
<UpdateParameters>
<asp:SessionParameter Name="UserName" SessionField="UserName" Type="String" DefaultValue="VaderRox" />
<asp:Parameter Name="MovieTitle" Type="String" />
<asp:Parameter Name="Movieid" Type="String" />
<asp:Parameter Name="review" Type="String" />
<asp:Parameter Name="rating" Type="String" />
</UpdateParameters>
<InsertParameters>
<asp:SessionParameter Name="UserName" SessionField="UserName" Type="String" DefaultValue="VaderRox" />
<asp:Parameter Name="MovieTitle" Type="String" />
<asp:Parameter Name="Movieid" Type="String" />
<asp:Parameter Name="review" Type="String" />
<asp:Parameter Name="rating" Type="String" />
</InsertParameters>
</asp:SqlDataSource>

我尝试过：



我不知道哪里可以诚实地开始

What I have tried:

I have no idea where to even start honestly

推荐答案

ConnectionStrings：Database1ConnectionString％>
ProviderName =<％

ConnectionStrings:Database1ConnectionString %>" ProviderName="<%

ConnectionStrings：Database1ConnectionString.ProviderName％>
SelectCommand =SELECT [MovieID]，[MovieTitle] FROM [movies_table] ORDER BY [Movietitle]， [MovieID]>< / asp：SqlDataSource>
< / ItemTemplate>
< / asp：TemplateField>
< asp：BoundField DataField =MovieTitleHeaderText = MovieTitle/>
< asp：BoundField DataField =MovieIDHeaderText =MovieID/>
< asp：BoundField DataField =RatingHeaderText =Rating/>
< asp：BoundField DataField =ReviewHeaderText =Review/>
< / Fields>
< / asp：DetailsView>



< asp：SqlDataSource ID =moviedatasource
ConnectionString =
<％

ConnectionStrings:Database1ConnectionString.ProviderName %>" SelectCommand="SELECT [MovieID], [MovieTitle] FROM [movies_table] ORDER BY [Movietitle], [MovieID]"></asp:SqlDataSource> </ItemTemplate> </asp:TemplateField> <asp:BoundField DataField="MovieTitle" HeaderText="MovieTitle" /> <asp:BoundField DataField="MovieID" HeaderText="MovieID" /> <asp:BoundField DataField="Rating" HeaderText="Rating" /> <asp:BoundField DataField="Review" HeaderText="Review" /> </Fields> </asp:DetailsView> <asp:SqlDataSource ID="moviedatasource" ConnectionString= "<%

ConnectionStrings：Database1ConnectionString％>
ProviderName =<％

ConnectionStrings:Database1ConnectionString %>" ProviderName="<%

这篇关于使用查询绑定下拉列表中的两组数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！