如何使用gridview内的下拉列表绑定数据表？ [英] How do bind datatable with dropdownlist which is inside gridview?

问题描述

我的gridview看起来如下，



< asp：GridView ID =GridView1runat =server AutoGenerateColumns =FalseOnRowDataBound =GridView1_RowDataBoundBackColor =WhiteBorderColor =＃CC9966BorderStyle =NoneBorderWidth =1pxCellPadding =4>

< Columns>

< asp：BoundField DataField =EmpIDHeaderText =EmpID>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：BoundField>

< asp：BoundField DataField =EmpNameHeaderText =EmpName >

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< ; / asp：BoundField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate1runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate2runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< Header Style Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate3runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ; ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate> ;

< asp：DropDownList ID =ddlAttendanceTypeDate4runat = server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/ >

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate5runat =server>

< / asp： DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False />

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate6runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate7runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate8runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ; ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDat e9runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap = False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate10runat =server>

< ; / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =假/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate11runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate12runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate13runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ; ItemTemplate>

< asp：DropDownList ID =ddlAtt endanceTypeDate14runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap = False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate15runat =server>

< ; / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>
< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate16runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate17runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate18runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ; ItemTemplate>

< asp：DropDownList ID =ddlAttendanc eTypeDate19runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap = False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate20runat =server>

< ; / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =假/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate21runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ; ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate22runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate23runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ; ItemTemplate>

< asp：DropDownList I. D =ddlAttendanceTypeDate24runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate25runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ; ItemStyle Wrap =False/>

< / asp：TemplateFi eld>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate26runat =server >

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate27runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate28runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDown列表ID =ddlAttendanceTypeDate29runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< ; HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate30runat =server>

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：Temp lateField>

< asp：TemplateField>

< ItemTemplate>

< asp：DropDownList ID =ddlAttendanceTypeDate31runat =server >

< / asp：DropDownList>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =False/>

< / asp：TemplateField>

< asp：TemplateField HeaderText =团队负责人备注>

< ItemTemplate>

< asp：TextBox ID =txtTeamLeaderRemarksrunat =server>< / asp：TextBox>

< / ItemTemplate>

< HeaderStyle Wrap =False/>

< ItemStyle Wrap =True/>

< / asp：TemplateField>



我的问题是，如何为这个gridview分配多个包含数据表值的记录，列可能会根据月份和年份增加或减少？

Hi,
My gridview looks like following,

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" OnRowDataBound="GridView1_RowDataBound" BackColor="White" BorderColor="#CC9966" BorderStyle="None" BorderWidth="1px" CellPadding="4">
<Columns>
<asp:BoundField DataField="EmpID" HeaderText="EmpID" >
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:BoundField>
<asp:BoundField DataField="EmpName" HeaderText="EmpName" >
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:BoundField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate1" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate2" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate3" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate4" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate5" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate6" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate7" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate8" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate9" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate10" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate11" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate12" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate13" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate14" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate15" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate16" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate17" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate18" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate19" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate20" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate21" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate22" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate23" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate24" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate25" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate26" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate27" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate28" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate29" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate30" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField>
<ItemTemplate>
<asp:DropDownList ID="ddlAttendanceTypeDate31" runat="server">
</asp:DropDownList>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="False" />
</asp:TemplateField>
<asp:TemplateField HeaderText="Team Leader Remarks">
<ItemTemplate>
<asp:TextBox ID="txtTeamLeaderRemarks" runat="server"></asp:TextBox>
</ItemTemplate>
<HeaderStyle Wrap="False" />
<ItemStyle Wrap="True" />
</asp:TemplateField>

My question is, How to assign more than one record contain datatable values to this gridview, column may be increase or decrease based on month and year?

推荐答案

看看这个：如何在ASP.Net中的GridView中填充DropDownList [ ^ ]

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