📄 editabledatalist.aspx
字号:
<%@ Page Language="VB" AutoEventWireup="false"
CodeFile="EditableDataList.aspx.vb" Inherits="EditableDataList" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>ASP.NET 2.0 Data Sources and Databound Controls Test Site</title>
</head>
<body bottommargin="10" topmargin="10">
<form id="frmEditable" runat="server">
<div>
<table style="width: 100%; height: 100%" cellspacing="0" cellpadding="0" border="0" id="tblMain" bgcolor="gainsboro">
<tr>
<td style="height: 31px">
<span style="font-size: 14pt; font-family: Arial"><b> Test Web Site for Data Sources
and Controls - Editable DataList <asp:DropDownList ID="ddlCountry" Runat="server" Height="22px"
Width="121px" DataSourceID="dsCountries" DataTextField="ShipCountry" DataValueField="ShipCountry"
AutoPostBack="True" Font-Size="10pt" Font-Names="Verdana">
</asp:DropDownList>
<asp:SqlDataSource
ID="dsCountries" Runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT DISTINCT [ShipCountry] FROM [Orders] ORDER BY [ShipCountry]">
</asp:SqlDataSource></b></span></td>
</tr>
<tr>
<td>
<asp:DataList ID="dlOrders" Runat="server" DataKeyField="OrderID" DataSourceID="dsOrders"
BorderColor="#999999" BackColor="#EEEEEE" BorderWidth="1px" GridLines="Vertical"
BorderStyle="None" CellPadding="3" Font-Names="Verdana" Font-Size="10pt"
Width="100%" Height="50px" RepeatColumns="2" RepeatDirection="Horizontal" ShowFooter="False" ShowHeader="False">
<FooterStyle ForeColor="Black" BackColor="#CCCCCC"></FooterStyle>
<ItemTemplate>
OrderID:
<asp:Label ID="OrderIDLabel" Runat="server" Text='<%# Eval("OrderID") %>'></asp:Label>
CustomerID:
<asp:Label ID="CustomerIDLabel" Runat="server" Text='<%# Eval("CustomerID") %>'></asp:Label><br />
EmployeeID:
<asp:Label ID="EmployeeIDLabel" Runat="server" Text='<%# Eval("EmployeeID") %>'></asp:Label>
OrderDate:
<asp:Label ID="OrderDateLabel" Runat="server" Text='<%# Eval("OrderDate", "{0:d}") %>'></asp:Label><br />
RequiredDate:
<asp:Label ID="RequiredDateLabel" Runat="server" Text='<%# Eval("RequiredDate", "{0:d}") %>'></asp:Label>
ShippedDate:
<asp:Label ID="ShippedDateLabel" Runat="server" Text='<%# Eval("ShippedDate", "{0:d}") %>'></asp:Label><br />
ShipVia:
<asp:Label ID="ShipViaLabel" Runat="server" Text='<%# Eval("ShipVia") %>'></asp:Label>
Freight:
<asp:Label ID="FreightLabel" Runat="server" Text='<%# Eval("Freight", "{0:C}") %>'></asp:Label><br />
ShipName:
<asp:Label ID="ShipNameLabel" Runat="server" Text='<%# Eval("ShipName") %>'></asp:Label><br />
<asp:Button ID="btnEdit" Runat="server" Width="94px" Height="24px" Text="Edit Order"
CommandName="edit" />
</ItemTemplate>
<ItemStyle ForeColor="Black" BackColor="#EEEEEE"></ItemStyle>
<EditItemTemplate>
OrderID:
<asp:TextBox ID="TextBox1" Runat="server" Text='<%# Eval("OrderID") %>' Width="60px" ReadOnly="True"></asp:TextBox>
CustomerID:
<asp:TextBox ID="TextBox2" Runat="server" Text='<%# Eval("CustomerID") %>' Width="60px"></asp:TextBox><br />
EmployeeID:
<asp:TextBox ID="TextBox3" Runat="server" Text='<%# Eval("EmployeeID") %>' Width="19px"></asp:TextBox>
OrderDate:
<asp:TextBox ID="TextBox4" Runat="server" Text='<%# Eval("OrderDate", "{0:d}") %>' Width="70px"></asp:TextBox><br />
RequiredDate:
<asp:TextBox ID="TextBox5" Runat="server" Text='<%# Eval("RequiredDate", "{0:d}") %>' Width="70px"></asp:TextBox>
ShippedDate:
<asp:TextBox ID="TextBox6" Runat="server" Text='<%# Eval("ShippedDate", "{0:d}") %>' Width="70px"></asp:TextBox><br />
ShipVia:
<asp:TextBox ID="TextBox7" Runat="server" Text='<%# Eval("ShipVia") %>' Width="19px"></asp:TextBox>
Freight:
<asp:TextBox ID="TextBox8" Runat="server" Text='<%# Eval("Freight", "{0:C}") %>' Width="61px"></asp:TextBox><br />
ShipName:
<asp:TextBox ID="TextBox9" Runat="server" Text='<%# Eval("ShipName") %>' Width="275px"></asp:TextBox><br />
<asp:Button ID="btnUpdate" Runat="server" Width="86px" Height="24px" Text="Update"
CommandName="update" />
<asp:Button ID="btnCancel" Runat="server" Width="81px" Height="24px" Text="Cancel"
CommandName="cancel" />
</EditItemTemplate>
<SelectedItemStyle ForeColor="White" Font-Bold="True" BackColor="SteelBlue"></SelectedItemStyle>
<HeaderStyle ForeColor="White" Font-Bold="True" BackColor="#000084"></HeaderStyle>
</asp:DataList>
<asp:SqlDataSource ID="dsOrders" Runat="server"
SelectCommand="SELECT [OrderID], [CustomerID], [EmployeeID], [OrderDate], [RequiredDate], [ShippedDate], [ShipVia], [Freight], [ShipName] FROM [Orders] WHERE ([ShipCountry] = @ShipCountry) ORDER BY [OrderID] DESC"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
DeleteCommand="DELETE FROM [Orders] WHERE [OrderID] = @original_OrderID"
InsertCommand="INSERT INTO [Orders] ([CustomerID], [EmployeeID], [OrderDate], [RequiredDate], [ShippedDate], [ShipVia], [Freight], [ShipName]) VALUES (@CustomerID, @EmployeeID, @OrderDate, @RequiredDate, @ShippedDate, @ShipVia, @Freight, @ShipName)"
UpdateCommand="UPDATE [Orders] SET [CustomerID] = @CustomerID, [EmployeeID] = @EmployeeID, [OrderDate] = @OrderDate, [RequiredDate] = @RequiredDate, [ShippedDate] = @ShippedDate, [ShipVia] = @ShipVia, [Freight] = @Freight, [ShipName] = @ShipName WHERE [OrderID] = @original_OrderID">
<DeleteParameters>
<asp:Parameter Type="Int32" Name="OrderID"></asp:Parameter>
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Type="String" Name="CustomerID"></asp:Parameter>
<asp:Parameter Type="Int32" Name="EmployeeID"></asp:Parameter>
<asp:Parameter Type="DateTime" Name="OrderDate"></asp:Parameter>
<asp:Parameter Type="DateTime" Name="RequiredDate"></asp:Parameter>
<asp:Parameter Type="DateTime" Name="ShippedDate"></asp:Parameter>
<asp:Parameter Type="Int32" Name="ShipVia"></asp:Parameter>
<asp:Parameter Type="Decimal" Name="Freight"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipName"></asp:Parameter>
<asp:Parameter Type="Int32" Name="original_OrderID"></asp:Parameter>
</UpdateParameters>
<SelectParameters>
<asp:ControlParameter Name="ShipCountry" DefaultValue="USA" Type="String" ControlID="ddlCountry"
PropertyName="SelectedValue"></asp:ControlParameter>
</SelectParameters>
<InsertParameters>
<asp:Parameter Type="String" Name="CustomerID"></asp:Parameter>
<asp:Parameter Type="Int32" Name="EmployeeID"></asp:Parameter>
<asp:Parameter Type="DateTime" Name="OrderDate"></asp:Parameter>
<asp:Parameter Type="DateTime" Name="RequiredDate"></asp:Parameter>
<asp:Parameter Type="DateTime" Name="ShippedDate"></asp:Parameter>
<asp:Parameter Type="Int32" Name="ShipVia"></asp:Parameter>
<asp:Parameter Type="Decimal" Name="Freight"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipName"></asp:Parameter>
</InsertParameters>
</asp:SqlDataSource>
</td>
</tr>
</table>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -