Gridview中的下拉菜单 [英] Dropdown inside Gridview

查看：59 发布时间：2019/6/22 1:48:34 C# ASP.NET

本文介绍了Gridview中的下拉菜单的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我在gridview中使用下拉菜单.下拉列表显示项目列表.
在这里，我想选择该商品的商品名称标签显示率.
请让我知道，如果我实际上需要将速率标签与数据库绑定，我已经绑定了下拉列表，并同时按数据库进行了标签，然后GridView在下拉列表中显示了所有项目名称，在标签中显示了速率，但是我希望当用户从下拉列表中选择项目名称时，尊重标签速率显示项目率.

我的aspx页面是.

Hi,
I am using dropdown inside gridview. The dropdown shows item list.
Here I want on selection of item name label display rate for that item.
Please let me know if I need to bind rate label with database actually i have bind dropdown and label both by database then gridview display all item name in dropdown and rate in label but i want when user select item name from dropdown then label rate display respected item rate.

my aspx page is.

 <asp:GridView ID="grd1" runat="server" DataSourceID="SqlDataSource1"
     AutoGenerateColumns="False" DataKeyNames="Product_Id" OnRowDataBound="grd1_RowDataBound">
     <Columns>
         <asp:TemplateField HeaderText="Product_Name" SortExpression="Product_Name">
             <ItemTemplate>
                 <asp:DropDownList ID="DropDownList1" AutoPostBack="true" runat="server" DataSourceID="SqlDataSource2"
                     DataTextField="Product_Name" Width="100px" DataValueField="Product_Id" AppendDataBoundItems="true" SelectedValue='<%# Bind("Product_ID") %>'>
                 </asp:DropDownList>
             </ItemTemplate>
         </asp:TemplateField>
         <asp:BoundField DataField="Product_Rate" SortExpression="Product_Rate" HeaderText="Product_Rate"/>
         <asp:TemplateField HeaderText="Product_Quantity" SortExpression="Product_Quantity">
         <EditItemTemplate>
         <asp:TextBox ID="txtQty" runat="server"/>
         </EditItemTemplate>
         </asp:TemplateField>
         <asp:TemplateField HeaderText="Product_Amount" SortExpression="Product_Amount">
         <ItemTemplate>
         <asp:Label ID="lblAmount" runat="server" />
         </ItemTemplate>
         </asp:TemplateField>
     </Columns>
 </asp:GridView>
 <asp:SqlDataSource ID="SqlDataSource1" runat="server"
     ConnectionString="<%$ ConnectionStrings:chalk_hillConnectionString %>"
     SelectCommand="SELECT [Product_Id],[Product_Name], [Product_Rate]  FROM [Product_Detail]">
 </asp:SqlDataSource>
         <asp:SqlDataSource ID="SqlDataSource2" runat="server"
     ConnectionString="<%$ ConnectionStrings:chalk_hillConnectionString %>"
     SelectCommand="SELECT [Product_Id],[Product_Name] FROM [Product_Detail]">
 </asp:SqlDataSource>
 <tr><td align="center">
  <asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClick="Submit"/>
  <asp:Button ID="Button1" runat="server" Text="Clear" OnClick="Clear"/>
  </td></tr>
 </table>
</center>

推荐答案

ConnectionStrings:chalk_hillConnectionString ％> " SelectCommand = " > < /asp:SqlDataSource > < asp:SqlDataSource ID =" runat 服务器" ConnectionString = " <％

ConnectionStrings:chalk_hillConnectionString %>" SelectCommand="SELECT [Product_Id],[Product_Name], [Product_Rate] FROM [Product_Detail]"> </asp:SqlDataSource> <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%

ConnectionStrings:chalk_hillConnectionString ％> " SelectCommand = " >> < /asp:SqlDataSource > < tr > < td =" center" > ; < asp:Button ID =" runat 服务器" 文本提交" OnClick 提交" / < asp:Button ID =" runat 服务器" 文本清除" OnClick 清除" > < /td > < /tr > < /table > < /center >

ConnectionStrings:chalk_hillConnectionString %>" SelectCommand="SELECT [Product_Id],[Product_Name] FROM [Product_Detail]"> </asp:SqlDataSource> <tr><td align="center"> <asp:Button ID="btnSubmit" runat="server" Text="Submit" OnClick="Submit"/> <asp:Button ID="Button1" runat="server" Text="Clear" OnClick="Clear"/> </td></tr> </table> </center>

< div width =" height =">< pre lang ="xml">& lt; asp:GridView ID =& quot ; grd1& quot; runat =&服务器" DataSourceID =& quot; SqlDataSource1& quot;
AutoGenerateColumns =&假& amp;". DataKeyNames =& quot; Product_Id& quot; OnRowDataBound =&"grd1_RowDataBound&";
& lt;列& gt;
& lt; asp:TemplateField HeaderText =& quot; Product_Name& quot; SortExpression =& quot; Product_Name& quot;& gt;
& lt; ItemTemplate& gt;
< asp:DropDownList ID =& quot; DropDownList1& quot; AutoPostBack =&"true&" runat =&服务器" DataSourceID =& quot; SqlDataSource2& quot;
DataTextField =& quot; Product_Name& quot;宽度=&"100px&" DataValueField =& quot; Product_Id& quot; AppendDataBoundItems =&"true&" SelectedValue ='& lt;％#Bind(& quot; Product_ID& quot;)％& gt;'& gt;
& lt;/asp:DropDownList& gt;
& lt;/ItemTemplate& gt;
& lt;/asp:TemplateField& gt;
& lt; asp:BoundField DataField =& quot; Product_Rate& quot; SortExpression =& quot; Product_Rate& quot; HeaderText =& quot; Product_Rate& quot;/& gt;
& lt; asp:TemplateField HeaderText =& quot; Product_Quantity& quot; SortExpression =& quot; Product_Quantity& quot;<
& lt; EditItemTemplate& gt;
& lt; asp:TextBox ID =& quot; txtQty& quot; runat =& quot;服务器& quot;/& gt;
& lt;/EditItemTemplate& gt;
& lt;/asp:TemplateField& gt;
& lt; asp:TemplateField HeaderText =& quot; Product_Amount& quot; SortExpression =& quot; Product_Amount& quot;<
& lt; ItemTemplate& gt;
< asp:标签ID =& quot; lblAmount& amp; quot; runat =&服务器" /& gt;
& lt;/ItemTemplate& gt;
& lt;/asp:TemplateField& gt;
& lt;/列& gt;
& lt;/asp:GridView</pre>
></div>

然后私有void dgvData_CellMouseClick(对象发送者，DataGridViewCellMouseEventArgs e)
{
}

在这种情况下，编写代码块

<div width="" height=""><pre lang="xml"><asp:GridView ID="grd1" runat="server" DataSourceID="SqlDataSource1"
AutoGenerateColumns="False" DataKeyNames="Product_Id" OnRowDataBound="grd1_RowDataBound">
<Columns>
<asp:TemplateField HeaderText="Product_Name" SortExpression="Product_Name">
<ItemTemplate>
<asp:DropDownList ID="DropDownList1" AutoPostBack="true" runat="server" DataSourceID="SqlDataSource2"
DataTextField="Product_Name" Width="100px" DataValueField="Product_Id" AppendDataBoundItems="true" SelectedValue='<%# Bind("Product_ID") %>'>
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:BoundField DataField="Product_Rate" SortExpression="Product_Rate" HeaderText="Product_Rate"/>
<asp:TemplateField HeaderText="Product_Quantity" SortExpression="Product_Quantity">
<EditItemTemplate>
<asp:TextBox ID="txtQty" runat="server"/>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Product_Amount" SortExpression="Product_Amount">
<ItemTemplate>
<asp:Label ID="lblAmount" runat="server" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView</pre>
></div>

then private void dgvData_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
}

in this event write the code block

这篇关于Gridview中的下拉菜单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文

Gridview中的下拉菜单 [英] Dropdown inside Gridview

问题描述

推荐答案

相关文章

其他开发语言最新文章

热门教程

热门工具

登录关闭

Gridview中的下拉菜单 [英] Dropdown inside Gridview

问题描述

推荐答案

相关文章

其他开发语言最新文章

热门教程

热门工具

登录 关闭

登录关闭