GridView模板列示范代码

本文介绍了一个使用ASP.NET实现的员工信息管理界面,通过GridView控件展示了员工数据,并提供了编辑、删除等功能。特别之处在于使用了自定义模板列来显示员工的出生日期和上司信息。
None.gif  //页面源代码
        
<form id="form1" runat="server">
None.gif    
<div style="text-align: center">
None.gif        
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4" ForeColor="#333333" GridLines="None" DataSourceID="EmployeeList">
None.gif            
<Columns>
None.gif                
<asp:CommandField ShowSelectButton="True" />
None.gif                
<asp:CommandField ShowEditButton="True" />
None.gif                
<asp:CommandField ShowDeleteButton="True" />
None.gif                
<asp:BoundField DataField="EmployeeID" HeaderText="雇员ID号" />
None.gif                
<asp:BoundField DataField="Name" HeaderText="雇员姓名" />
None.gif                
<asp:TemplateField HeaderText="BirthDate出生日期" SortExpression="BirthDate">
None.gif                    
<EditItemTemplate>
None.gif                        
<asp:Calendar ID="Calendar1" runat="server" BackColor="#FFFFCC" BorderColor="#FFCC66"
None.gif                            BorderWidth
="1px" DayNameFormat="Shortest" Font-Names="Verdana" Font-Size="8pt"
None.gif                            ForeColor
="#663399" Height="200px" SelectedDate='<%# Bind("BirthDate") %>' ShowGridLines="True"
None.gif                            VisibleDate
='<%# Eval("BirthDate") %>' Width="220px">
None.gif                            
<SelectedDayStyle BackColor="#CCCCFF" Font-Bold="True" />
None.gif                            
<TodayDayStyle BackColor="#FFCC66" ForeColor="White" />
None.gif                            
<SelectorStyle BackColor="#FFCC66" />
None.gif                            
<OtherMonthDayStyle ForeColor="#CC9966" />
None.gif                            
<NextPrevStyle Font-Size="9pt" ForeColor="#FFFFCC" />
None.gif                            
<DayHeaderStyle BackColor="#FFCC66" Font-Bold="True" Height="1px" />
None.gif                            
<TitleStyle BackColor="#990000" Font-Bold="True" Font-Size="9pt" ForeColor="#FFFFCC" />
None.gif                        
</asp:Calendar>
None.gif                    
</EditItemTemplate>
None.gif                    
<ItemTemplate>
None.gif                        
<asp:Label ID="Label2" runat="server" Text='<%# Bind("BirthDate", "{0:d}") %>'></asp:Label>
None.gif                    
</ItemTemplate>
None.gif                
</asp:TemplateField>
None.gif                
<asp:TemplateField HeaderText="上司">
None.gif                    
<EditItemTemplate>
None.gif                        
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="ReportsToList"
None.gif                            DataTextField
="Name" DataValueField="EmployeeID" SelectedValue='<%# Bind("Commander") %>'>
None.gif                        
</asp:DropDownList>&nbsp;
None.gif                    
</EditItemTemplate>
None.gif                    
<ItemTemplate>
None.gif                        
<asp:Label ID="Label1" runat="server" Text='<%# GetReportsToName(Eval("Commander")) %>'></asp:Label>
None.gif                    
</ItemTemplate>
None.gif                
</asp:TemplateField>
None.gif            
</Columns>
None.gif            
<FooterStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
None.gif            
<RowStyle BackColor="#F7F6F3" ForeColor="#333333" />
None.gif            
<EditRowStyle BackColor="#999999" />
None.gif            
<SelectedRowStyle BackColor="#E2DED6" Font-Bold="True" ForeColor="#333333" />
None.gif            
<PagerStyle BackColor="#284775" ForeColor="White" HorizontalAlign="Center" />
None.gif            
<HeaderStyle BackColor="#5D7B9D" Font-Bold="True" ForeColor="White" />
None.gif            
<AlternatingRowStyle BackColor="White" ForeColor="#284775" />
None.gif        
</asp:GridView>
None.gif    
None.gif    
</div>
None.gif        
<asp:SqlDataSource ID="EmployeeList" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
None.gif            SelectCommand
="SELECT EmployeeID, LastName + ',' + FirstName AS Name, BirthDate, ReportsTo AS Commander FROM Employees">
None.gif        
</asp:SqlDataSource>
None.gif        
<asp:SqlDataSource ID="ReportsToList" runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
None.gif            SelectCommand
="Select EmployeeID,LastName+','+FirstName as Name From Employees Union Select Null,'无' Order by Name ASC">
None.gif        
</asp:SqlDataSource>
None.gif    
</form>
None.gif  //绑定第一个模板列的Label1控件,将EmployeeID转换为姓名
     
public string GetReportsToName(object reportsToId)
ExpandedBlockStart.gifContractedBlock.gif    
dot.gif{
InBlock.gif        
foreach (DataRowView row in ReportsToList.Select(DataSourceSelectArguments.Empty))
ExpandedSubBlockStart.gifContractedSubBlock.gif        
dot.gif{
InBlock.gif            
if (reportsToId.Equals(row["EmployeeID"]))
ExpandedSubBlockStart.gifContractedSubBlock.gif            
dot.gif{
InBlock.gif                
return row["Name"].ToString();
ExpandedSubBlockEnd.gif            }

ExpandedSubBlockEnd.gif        }

InBlock.gif        
throw new ArgumentException();
ExpandedBlockEnd.gif    }


转载于:https://www.cnblogs.com/yuzhixue/archive/2006/10/18/532211.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值