如何使用C＃将下拉列表绑定到数据库值内部在网格视图中编辑项模板文件 [英] How Do I Bind Dropdown List To Database Value Inside Edit Item Template File In Grid View Using C#

问题描述

我有一个GridView for TAX master我有一个名为tax_master的表在tax_master中我有一个列tax_status并且它的数据类型是位

现在我想用我的下拉列表自动编辑绑定数据库值按钮是真的



这是我的GridView代码

 < span class =code-keyword><   asp：TemplateField     HeaderText   = 有效 >  
 <   EditItemTemplate  >  
 <   asp：DropDownList     ID   =  tax_status    runat   =  server >  
 <   asp：ListItem    值  =  1  > 是<   / asp ：ListItem  >  
 <   asp：ListItem    值  =   0 > 否<   / asp：ListItem  < span class =code-keyword>>  
 <   / asp：DropDownList  >  
 <   / EditItemTemplate  >  
 <   ItemTemplate  >  
 <   asp：标签    ID   =   lbl_tax_status    runat   = 服务器 >  <％＃（ Boolean  .Parse（Eval（   tax_status）。ToString（）））？  是： 否 ％>  <   / asp：标签 >  
 <   / ItemTemplate  >  
 <   / asp：TemplateField  >  

当我点击编辑然后如果税状态为0即为假，那么我想在我的下拉列表中显示未选择默认值，如果我将其更改为1即True，则必须保存更改到数据库，反之亦然



请提前帮助我解决我的难题

解决方案

假设 tax_status 列的数据类型为位，请尝试：

< pre lang =asp.net> < EditItemTemplate >
< asp：DropDownList ID = tax_status runat = < span class =code-keyword> server SelectedValue =' <％ #Bind（ tax_status）％> ' >
< asp： ListItem 值 = True > 是< < span class =code-leadattribute> / asp：ListItem >
< asp：ListItem 值 < span class =code-keyword> = False > 否< / asp：ListItem >
< / asp：DropDownList >
< / EditItemTemplate >

I have a GridView for TAX master i have table with name tax_master inside tax_master i have a column tax_status and its data type is bit
Now i want to bind database value with my dropdown list autogenrate edit button is true

Here is my code for GridView

<asp:TemplateField HeaderText="Active">
                        <EditItemTemplate>
                            <asp:DropDownList ID="tax_status" runat="server">
                                <asp:ListItem Value="1">Yes</asp:ListItem>
                                <asp:ListItem Value="0">No</asp:ListItem>
                            </asp:DropDownList>
                        </EditItemTemplate>
                        <ItemTemplate>
                            <asp:Label ID="lbl_tax_status" runat="server"><%# (Boolean.Parse(Eval("tax_status").ToString())) ? "Yes" : "No" %></asp:Label>
                        </ItemTemplate>
                    </asp:TemplateField>

When i clicked on Edit Then If tax status is 0 i.e. false then i want to show the No default selected in my drop down list and if i changed it to 1 i.e. True then changes must be saved to database and vice-versa

Please help me to solve my puzzle thanks in advance

解决方案

Assuming the data type of your tax_status column is bit, try:

<EditItemTemplate>
    <asp:DropDownList ID="tax_status" runat="server" SelectedValue='<%# Bind("tax_status") %>'>
        <asp:ListItem Value="True">Yes</asp:ListItem>
        <asp:ListItem Value="False">No</asp:ListItem>
    </asp:DropDownList>
</EditItemTemplate>

这篇关于如何使用C＃将下拉列表绑定到数据库值内部在网格视图中编辑项模板文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！