加了 runat="server"属性的select控件的value和text(实际值和显示文本)

本文详细介绍了如何在ASP.NET Web应用程序中使用Select控件,并通过代码清空现有选项、绑定数据库数据及设置DataTextField属性来实现数据的动态显示。解释了在获取绑定数据时如何使用Value属性取值。

前台html:

加了 runat="server"属性的select控件

<select name="select0" class="inp005" runat="server" id="slParentProject">

                            <option selected>交通</option>
                            <option>通讯费</option>
                            <option>其他收入</option>

                        </select>


后台绑定数据:

                this.slParentProject.Items.Clear();
                this.slParentProject.DataSource = projects;//数据库取出的对象
                this.slParentProject.DataValueField = "ID";
               // this.slParentProject.DataTextField = "ProjectName"; //这里设置了DataTextField属性的话,就显示数据库中对应的字段值,如果不设定,就显示DataValueField所绑定的值。
                this.slParentProject.DataBind();


设置了DataTextField属性


没有设置DataTextField属性,显示的是ID值(我用的Guid做主键)



后台如果要取用绑定在select控件中的ID时可以使用它的value属性

string parentIDStr = this.slParentProject.Value;//这里就如同一般情况下的加了runat="server"属性的Html控件在后台的取值方式

<html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> </head> <style type="text/css"> .GridViewStyle { border-collapse: collapse; width: 100%; text-align:center } .GridViewStyle th, .GridViewStyle td { border: 1px solid #ddd; padding: 8px; } .GridViewStyle tr:hover { background-color: #f1f1f1; } </style> <body> <form id="form1" runat="server"> <div> <asp:Button ID="downloadmon1" runat="server" Text="下载数据" OnClick="downloadmon1_Click" /> <asp:FileUpload ID="FileUp" runat="server" Text="选择文件"/> <asp:Button ID="btn_ExInto_pass" runat="server" Text="导入" OnClick="btn_ExInto_pass_Click" /> </div> <div> <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" CssClass="GridViewStyle" DataKeyNames="Dept,Week,Month" AutoGenerateEditButton="False" AllowPaging="True" PageSize="20" Visible="false"> <Columns> <asp:BoundField DataField="Plant" HeaderText="Plant" ReadOnly="True" /> <asp:BoundField DataField="Dept" HeaderText="Dept" ReadOnly="True"/> <asp:BoundField DataField="Month" HeaderText="Month" ReadOnly="True"/> <asp:BoundField DataField="Week" HeaderText="Week" ReadOnly="True"/> <asp:TemplateField HeaderText="OT_Time"> <ItemTemplate> <asp:Label ID="lblEmail" runat="server" Text='<%# Bind("OT_Time") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="txtEmail" runat="server" Text='<%# Bind("OT_Time") %>'></asp:TextBox> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField ShowHeader="False"> <ItemTemplate> <asp:LinkButton ID="lnkEdit" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit"></asp:LinkButton> </ItemTemplate> <EditItemTemplate> <asp:LinkButton ID="lnkUpdate" runat="server" CommandName="Update" Text="Update"></asp:LinkButton> <asp:LinkButton ID="lnkCancel" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"></asp:LinkButton> </EditItemTemplate> </asp:TemplateField> </Columns> <HeaderStyle Wrap="False" /> </asp:GridView> </div> <div> <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CssClass="GridViewStyle" DataKeyNames="Dept,Week,Month" DataSourceID="SqlDataSource1" AutoGenerateEditButton="False" AllowPaging="True" PageSize="20"> <Columns> <asp:BoundField DataField="Plant" HeaderText="Plant" ReadOnly="True" /> <asp:BoundField DataField="Dept" HeaderText="Dept" ReadOnly="True"/> <asp:BoundField DataField="Month" HeaderText="Month" ReadOnly="True"/> <asp:BoundField DataField="Week" HeaderText="Week" ReadOnly="True"/> <asp:TemplateField HeaderText="OT_Time"> <ItemTemplate> <asp:Label ID="lblEmail" runat="server" Text='<%# Bind("OT_Time") %>'></asp:Label> </ItemTemplate> <EditItemTemplate> <asp:TextBox ID="txtEmail" runat="server" Text='<%# Bind("OT_Time") %>'></asp:TextBox> </EditItemTemplate> </asp:TemplateField> <asp:TemplateField ShowHeader="False"> <ItemTemplate> <asp:LinkButton ID="lnkEdit" runat="server" CausesValidation="False" CommandName="Edit" Text="Edit"></asp:LinkButton> </ItemTemplate> <EditItemTemplate> <asp:LinkButton ID="lnkUpdate" runat="server" CommandName="Update" Text="Update"></asp:LinkButton> <asp:LinkButton ID="lnkCancel" runat="server" CausesValidation="False" CommandName="Cancel" Text="Cancel"></asp:LinkButton> </EditItemTemplate> </asp:TemplateField> </Columns> <HeaderStyle Wrap="False" /> </asp:GridView> <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ApplicationServices %>" SelectCommand="SELECT A.* FROM [Assembly].[dbo].[MPE_HC_OT] AS A LEFT JOIN (SELECT TOP 1 'WW'+Week AS Time FROM [Assembly].[dbo].[MPE_Loading_PTime_Dept_Week] WHERE DEPT='AG1') AS B ON A.WEEK>= B.TIME WHERE A.Week >= B.Time ORDER BY A.Month" UpdateCommand="UPDATE MPE_HC_OT SET OT_Time=@OT_Time,OT_Time_Active='1' WHERE Dept=@Dept and Month=@Month and Week= @Week"> </asp:SqlDataSource> </div> </form> </body> </html>
最新发布
08-16
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值