清单 D
<%@ Page Language="C#" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server"><title>DetailsView Example</title></head>
<body>
<form id="frmDetailsViewExample" runat="server">
<asp:SqlDataSource ID="dsExample" ConnectionString="Server=localhost;Database=Northwind;Trusted_Connection=true" SelectCommand="SELECT EmployeeID, LastName, FirstName, HomePhone, HireDate FROM Employees" Runat="Server" UpdateCommand="UPDATE Employees SET LastName=@LastName, FirstName=@FirstName, HomePhone=@HomePhone, HireDate=@HireDate WHERE EmployeeID=@EmployeeID"?DeleteCommand="DELETE FROM Employees WHERE EmployeeID=@EmployeeID" InsertCommand="INSERT INTO Employees (LastName, FirstName, HomePhone, HireDate) VALUES (@LastName, @FirstName, @HomePhone, @HireDate) />
<asp:DetailsView ID="dvExample" runat="server" Height="50px" Width="125px" DataSourceID="dsExample" AllowPaging="true" AutoGenerateDeleteButton="true" AutoGenerateInsertButton="true" AutoGenerateEditButton="true" AutoGenerateRows="false">
<Fields>
<asp:BoundFieldDataField="EmployeeID" HeaderText="ID:" ReadOnly="true" />
<asp:BoundFieldDataField="LastName" HeaderText="Last Name:" />
<asp:BoundFieldDataField="FirstName" HeaderText="First Name:" />
<asp:BoundFieldDataField="HomePhone" HeaderText="Telephone:" />
<asp:TemplateFieldHeaderText="Hire Date">
<ItemTemplate>
<asp:Label ID="lblHireDate" Runat="Server"
Text='<%# Eval("BirthDate", "{0:d}") %>' />
</ItemTemplate>
<InsertItemTemplate>
<asp:Calendar ID="calInsertHireDate" Runat="Server"SelectedDate='<%# Bind("HireDate") %>' />
</InsertItemTemplate>
<EditItemTemplate>
<asp:Calendar ID="calEditHireDate" Runat="Server"VisibleDate='<%# Eval("HireDate") %>'SelectedDate='<%# Bind("HireDate") %>' />
</EditItemTemplate>
</asp:TemplateField>
</Fields>
</asp:DetailsView>
</form></body></html>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server"><title>DetailsView Example</title></head>
<body>
<form id="frmDetailsViewExample" runat="server">
<asp:SqlDataSource ID="dsExample" ConnectionString="Server=localhost;Database=Northwind;Trusted_Connection=true" SelectCommand="SELECT EmployeeID, LastName, FirstName, HomePhone, HireDate FROM Employees" Runat="Server" UpdateCommand="UPDATE Employees SET LastName=@LastName, FirstName=@FirstName, HomePhone=@HomePhone, HireDate=@HireDate WHERE EmployeeID=@EmployeeID"?DeleteCommand="DELETE FROM Employees WHERE EmployeeID=@EmployeeID" InsertCommand="INSERT INTO Employees (LastName, FirstName, HomePhone, HireDate) VALUES (@LastName, @FirstName, @HomePhone, @HireDate) />
<asp:DetailsView ID="dvExample" runat="server" Height="50px" Width="125px" DataSourceID="dsExample" AllowPaging="true" AutoGenerateDeleteButton="true" AutoGenerateInsertButton="true" AutoGenerateEditButton="true" AutoGenerateRows="false">
<Fields>
<asp:BoundFieldDataField="EmployeeID" HeaderText="ID:" ReadOnly="true" />
<asp:BoundFieldDataField="LastName" HeaderText="Last Name:" />
<asp:BoundFieldDataField="FirstName" HeaderText="First Name:" />
<asp:BoundFieldDataField="HomePhone" HeaderText="Telephone:" />
<asp:TemplateFieldHeaderText="Hire Date">
<ItemTemplate>
<asp:Label ID="lblHireDate" Runat="Server"
Text='<%# Eval("BirthDate", "{0:d}") %>' />
</ItemTemplate>
<InsertItemTemplate>
<asp:Calendar ID="calInsertHireDate" Runat="Server"SelectedDate='<%# Bind("HireDate") %>' />
</InsertItemTemplate>
<EditItemTemplate>
<asp:Calendar ID="calEditHireDate" Runat="Server"VisibleDate='<%# Eval("HireDate") %>'SelectedDate='<%# Bind("HireDate") %>' />
</EditItemTemplate>
</asp:TemplateField>
</Fields>
</asp:DetailsView>
</form></body></html>
使用简便
ASP.NET 2.0的许多新功能都以易于使用为特征。对于与DetailsView控件结合起来的新型数据控件来说更是如此。做一些很简单的处理，你就可以访问和显示数据，并且还能不需要编写代码就支持编辑、删除和插入操作。
