📄 linkeddetailsview.aspx
字号:
<%@ Page Language="VB" Debug="true" AutoEventWireup="false" CodeFile="LinkedDetailsView.aspx.vb" Inherits="LinkedDetailsView_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 WSOrdersBE Web Service (Business Objects)</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 <asp:LinkButton
ID="lbLinkedDetails" Runat="server" PostBackUrl="~/LinkedGridView.aspx" Font-Size="11pt">Linked GridView</asp:LinkButton>
</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="odsOrderQueryString" DataKeyNames="OrderID" AutoGenerateRows="False" Width="326px" Height="390px">
<Fields>
<asp:BoundField HeaderText="Order ID" InsertVisible="False" DataField="OrderID"
SortExpression="OrderID" ReadOnly="True"></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 ShowDeleteButton="True" ShowInsertButton="True" ShowEditButton="True"></asp:CommandField>
</Fields>
</asp:DetailsView>
<asp:ObjectDataSource ID="odsOrderQueryString" Runat="server" TypeName="WSOrdersBE.WSOrdersBE"
SelectMethod="GetOrderByOrderID" DeleteMethod="DeleteOrder" InsertMethod="InsertOrder" UpdateMethod="UpdateOrder">
<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 Name="original_OrderID" Type="Int32" />
</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: 278px;" valign="top" colspan="1">
<asp:DetailsView ID="dvDetailsLinked" Runat="server" Height="183px" Width="254px"
AutoGenerateRows="False" DataSourceID="odsOrderDetailsLinked" AllowPaging="True" Font-Size="10pt" Font-Names="Verdana">
<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"></asp:CommandField>
</Fields>
</asp:DetailsView>
<asp:ObjectDataSource ID="odsOrderDetailsLinked" Runat="server" TypeName="WSOrdersBE.WSOrdersBE"
SelectMethod="GetDetailsByOrderID" DeleteMethod="DeleteDetail" InsertMethod="InsertDetail">
<DeleteParameters>
<asp:ControlParameter Name="OrderID" Type="Int32" ControlID="dvDetailsLinked" PropertyName="SelectedValue"></asp:ControlParameter>
<asp:ControlParameter Name="ProductID" Type="Int32" ControlID="dvDetailsLinked" PropertyName="SelectedValue"></asp:ControlParameter>
</DeleteParameters>
<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>
<asp:Label ID="lblHelp" Runat="server" Font-Size="10pt" Height="71px" Width="254px"
Font-Names="Verdana" Text="To Update an OrderDetail object, you must delete the existing object and then add a new object. If the order contains only one line item, you must add a new one and then delete the old version."></asp:Label> <br />
</td>
</tr>
<tr>
<td style="width: 152px; height: 50px; background-color: gainsboro" valign="top"
colspan="2">
</td>
<td style="width: 278px; 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 + -