📄 linkeddetailsviewbe.aspx
字号:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="LinkedDetailsViewBE.aspx.vb" Inherits="LinkedDetailsViewBE_aspx" EnableSessionState="True" Trace="true" TraceMode="SortByTime" %>
<!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 ObjectDataSources from Business Entities (ArrayList, Read-Write)</title>
</head>
<body style="font-size: 12pt" bottommargin="10" topmargin="10">
<form id="frmReadOnly" runat="server">
<div style="background-color: Gainsboro">
<div style="text-align: left">
<span style="font-size: 14pt; font-family: Arial"><b> Linked DetailsView Control (ODS
- Business Entity) <asp:LinkButton
ID="lbLinkedDetails" Runat="server" PostBackUrl="~/LinkedGridViewBE.aspx" Font-Size="11pt" ToolTip="Return to BusinessEntity GridView (ArrayList)">LinkedGridViewBE</asp:LinkButton>
<asp:TextBox ID="txtError" Runat="server" Font-Size="10pt" Height="16px" Width="704px"
Font-Names="Verdana" BorderStyle="Solid" BorderWidth="1px" ForeColor="Red" Visible="False"
TextMode="MultiLine"></asp:TextBox>
<br />
</b></span>
<table style="width: 665px; height: 419px" cellpadding="2" border="0">
<tr>
<td style=" height: 50px; background-color: gainsboro; width: 152px;" colspan="2" valign="top">
<asp:DetailsView ID="dvOrdersLinked" Runat="server" Font-Size="10pt" Font-Names="Verdana"
DataSourceID="odsOrdersLinked" AutoGenerateRows="False" Width="326px" Height="390px" DataKeyNames="OrderID">
<Fields>
<asp:BoundField HeaderText="Order ID" DataField="OrderID"
SortExpression="OrderID" ReadOnly="True" InsertVisible="False"></asp:BoundField>
<asp:BoundField HeaderText="Customer ID" DataField="CustomerID" SortExpression="CustomerID"></asp:BoundField>
<asp:BoundField HeaderText="Employee ID" DataField="EmployeeID" SortExpression="EmployeeID"></asp:BoundField>
<asp:BoundField HeaderText="Order Date" DataField="OrderDate" SortExpression="OrderDate" ApplyFormatInEditMode="True" DataFormatString="{0:d}"></asp:BoundField>
<asp:BoundField HeaderText="Required Date" DataField="RequiredDate" SortExpression="RequiredDate" ApplyFormatInEditMode="True" DataFormatString="{0:d}"></asp:BoundField>
<asp:BoundField HeaderText="Shipped Date" DataField="ShippedDate" SortExpression="ShippedDate" ApplyFormatInEditMode="True" DataFormatString="{0:d}" NullDisplayText="Pending"></asp:BoundField>
<asp:BoundField HeaderText="Ship Via" DataField="ShipVia" SortExpression="ShipVia"></asp:BoundField>
<asp:BoundField HeaderText="Freight" DataField="Freight" SortExpression="Freight" DataFormatString="{0:C}"></asp:BoundField>
<asp:BoundField HeaderText="Ship Name" DataField="ShipName" SortExpression="ShipName"></asp:BoundField>
<asp:BoundField HeaderText="Ship Address" DataField="ShipAddress" SortExpression="ShipAddress"></asp:BoundField>
<asp:BoundField HeaderText="Ship City" DataField="ShipCity" SortExpression="ShipCity"></asp:BoundField>
<asp:BoundField HeaderText="Ship Region" DataField="ShipRegion" SortExpression="ShipRegion"></asp:BoundField>
<asp:BoundField HeaderText="Ship Postal Code" DataField="ShipPostalCode" SortExpression="ShipPostalCode"></asp:BoundField>
<asp:BoundField HeaderText="Ship Country" DataField="ShipCountry" SortExpression="ShipCountry"></asp:BoundField>
<asp:CommandField ShowEditButton="True" ShowInsertButton="True" ShowDeleteButton="True"></asp:CommandField>
</Fields>
</asp:DetailsView>
<asp:ObjectDataSource ID="odsOrdersLinked" Runat="server" SelectMethod="GetOrderByOrderID"
TypeName="OrdersBE" UpdateMethod="UpdateOrder" DeleteMethod="DeleteOrder" InsertMethod="InsertOrder">
<DeleteParameters>
<asp:Parameter Name="original_OrderID" Type="Int32" />
</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="String" Name="ShipAddress"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipCity"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipRegion"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipPostalCode"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipCountry"></asp:Parameter>
<asp:Parameter Type="Int32" Name="original_OrderID"></asp:Parameter>
</UpdateParameters>
<SelectParameters>
<asp:QueryStringParameter Name="OrderID" DefaultValue="11077" QueryStringField="orderid"
Type="Int32"></asp:QueryStringParameter>
</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>
<asp:Parameter Type="String" Name="ShipAddress"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipCity"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipRegion"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipPostalCode"></asp:Parameter>
<asp:Parameter Type="String" Name="ShipCountry"></asp:Parameter>
</InsertParameters>
</asp:ObjectDataSource>
</td>
<td style="height: 50px; background-color: gainsboro; width: 226px;" valign="top" colspan="1">
<asp:DetailsView ID="dvDetailsLinked" Runat="server" Height="57px" Width="400px"
AutoGenerateRows="False" DataSourceID="odsOrderDetailsLinked" AllowPaging="True" Font-Size="10pt" Font-Names="Verdana" DataKeyNames="OrderID,ProductID">
<Fields>
<asp:BoundField HeaderText="Order ID" DataField="OrderID" SortExpression="OrderID"></asp:BoundField>
<asp:BoundField HeaderText="Product ID" DataField="ProductID" SortExpression="ProductID"></asp:BoundField>
<asp:BoundField HeaderText="Unit Price" DataField="UnitPrice" SortExpression="UnitPrice" DataFormatString="{0:C}"></asp:BoundField>
<asp:BoundField HeaderText="Quantity" DataField="Quantity" SortExpression="Quantity"></asp:BoundField>
<asp:BoundField HeaderText="Discount" DataField="Discount" SortExpression="Discount" DataFormatString="{0:p}"></asp:BoundField>
<asp:CommandField ShowDeleteButton="True" ShowInsertButton="True" ShowEditButton="True"></asp:CommandField>
</Fields>
</asp:DetailsView>
<asp:ObjectDataSource ID="odsOrderDetailsLinked" Runat="server" SelectMethod="GetDetailsByOrderID"
TypeName="OrdersBE" InsertMethod="InsertDetail" DeleteMethod="DeleteDetail" UpdateMethod="UpdateDetail">
<DeleteParameters>
<asp:ControlParameter Name="OrderID" Type="Int32" ControlID="dvOrdersLinked" PropertyName="SelectedValue"></asp:ControlParameter>
<asp:ControlParameter Name="ProductID" Type="Int32" ControlID="dvDetailsLinked" PropertyName="SelectedValue"></asp:ControlParameter>
</DeleteParameters>
<UpdateParameters>
<asp:ControlParameter Name="OrderID" Type="Int32" ControlID="dvDetailsLinked" PropertyName="SelectedValue"></asp:ControlParameter>
<asp:ControlParameter Name="ProductID" Type="Int32" ControlID="dvDetailsLinked" PropertyName="SelectedValue"></asp:ControlParameter>
<asp:ControlParameter Name="UnitPrice" Type="Decimal" ControlID="dvDetailsLinked"
PropertyName="SelectedValue"></asp:ControlParameter>
<asp:ControlParameter Name="Quantity" Type="Int16" ControlID="dvDetailsLinked" PropertyName="SelectedValue"></asp:ControlParameter>
<asp:ControlParameter Name="Discount" Type="Decimal" ControlID="dvDetailsLinked"
PropertyName="SelectedValue"></asp:ControlParameter>
<asp:ControlParameter Name="original_OrderID" Type="Int32" ControlID="dvDetailsLinked"
PropertyName="SelectedValue"></asp:ControlParameter>
<asp:ControlParameter Name="original_ProductID" Type="Int32" ControlID="dvDetailsLinked"
PropertyName="SelectedValue"></asp:ControlParameter>
</UpdateParameters>
<SelectParameters>
<asp:QueryStringParameter Name="OrderID" DefaultValue="11077" QueryStringField="orderid"
Type="Int32"></asp:QueryStringParameter>
</SelectParameters>
<InsertParameters>
<asp:Parameter Type="Int32" Name="OrderID"></asp:Parameter>
<asp:Parameter Type="Int32" Name="ProductID"></asp:Parameter>
<asp:Parameter Type="Decimal" Name="UnitPrice"></asp:Parameter>
<asp:Parameter Type="Int16" Name="Quantity"></asp:Parameter>
<asp:Parameter Type="Decimal" Name="Discount"></asp:Parameter>
</InsertParameters>
</asp:ObjectDataSource>
</td>
</tr>
<tr>
<td style="width: 152px; height: 50px; background-color: gainsboro" valign="top"
colspan="2">
</td>
<td style="width: 226px; height: 50px; background-color: gainsboro" valign="top"
colspan="1">
</td>
</tr>
</table>
</div>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -