📄 linkeddetailsview.aspx
字号:
<%@ Page Language="VB" AutoEventWireup="false" CodeFile="LinkedDetailsView.aspx.vb" Inherits="LinkedDetailsView" %>
<!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 id="Head1" runat="server">
<title>ASP.NET 2.0 GridView and DetailsView Controls</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="odsOrdersLinked" DataKeyNames="OrderID" DefaultMode="Edit" AutoGenerateRows="False" Width="326px" Height="390px">
<Fields>
<asp:BoundField HeaderText="Order ID" InsertVisible="False" DataField="OrderID"
SortExpression="OrderID"></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}"></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 ShowInsertButton="True" ShowEditButton="True"></asp:CommandField>
</Fields>
</asp:DetailsView>
<asp:ObjectDataSource ID="odsOrdersLinked" runat="server" DeleteMethod="Delete" InsertMethod="Insert"
SelectMethod="GetOrdersByOrderID" TypeName="NwindDAL.NorthwindDataSetTableAdapters.OrdersTableAdapter"
UpdateMethod="Update">
<DeleteParameters>
<asp:Parameter Name="Original_OrderID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="CustomerID" Type="String" />
<asp:Parameter Name="EmployeeID" Type="Int32" />
<asp:Parameter Name="OrderDate" Type="DateTime" />
<asp:Parameter Name="RequiredDate" Type="DateTime" />
<asp:Parameter Name="ShippedDate" Type="DateTime" />
<asp:Parameter Name="ShipVia" Type="Int32" />
<asp:Parameter Name="Freight" Type="Decimal" />
<asp:Parameter Name="ShipName" Type="String" />
<asp:Parameter Name="ShipAddress" Type="String" />
<asp:Parameter Name="ShipCity" Type="String" />
<asp:Parameter Name="ShipRegion" Type="String" />
<asp:Parameter Name="ShipPostalCode" Type="String" />
<asp:Parameter Name="ShipCountry" Type="String" />
<asp:Parameter Name="Original_OrderID" Type="Int32" />
<asp:Parameter Name="OrderID" Type="Int32" />
</UpdateParameters>
<SelectParameters>
<asp:QueryStringParameter DefaultValue="11077" Name="OrderID" QueryStringField="orderid"
Type="Int32" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="CustomerID" Type="String" />
<asp:Parameter Name="EmployeeID" Type="Int32" />
<asp:Parameter Name="OrderDate" Type="DateTime" />
<asp:Parameter Name="RequiredDate" Type="DateTime" />
<asp:Parameter Name="ShippedDate" Type="DateTime" />
<asp:Parameter Name="ShipVia" Type="Int32" />
<asp:Parameter Name="Freight" Type="Decimal" />
<asp:Parameter Name="ShipName" Type="String" />
<asp:Parameter Name="ShipAddress" Type="String" />
<asp:Parameter Name="ShipCity" Type="String" />
<asp:Parameter Name="ShipRegion" Type="String" />
<asp:Parameter Name="ShipPostalCode" Type="String" />
<asp:Parameter Name="ShipCountry" Type="String" />
</InsertParameters>
</asp:ObjectDataSource>
</td>
<td style="height: 50px; background-color: gainsboro" valign="top" colspan="1">
<asp:DetailsView ID="dvOrderDetailsLinked" Runat="server" Font-Size="10pt" AutoGenerateRows="False" DataKeyNames="OrderID,ProductID" DataSourceID="odsOrderDetailsLinked"
Font-Names="Verdana" AllowPaging="True" Height="142px" Width="237px">
<PagerSettings FirstPageText="First" LastPageText="Last" Mode="NumericFirstLast"></PagerSettings>
<PagerStyle Font-Names="Verdana" Font-Size="10pt"></PagerStyle>
<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"></asp:BoundField>
<asp:BoundField HeaderText="Quantity" DataField="Quantity" SortExpression="Quantity"></asp:BoundField>
<asp:BoundField HeaderText="Discount" DataField="Discount" SortExpression="Discount"></asp:BoundField>
<asp:CommandField ShowDeleteButton="True" ShowInsertButton="True" ShowEditButton="True"></asp:CommandField>
</Fields>
</asp:DetailsView>
<asp:ObjectDataSource ID="odsOrderDetailsLinked" runat="server" DeleteMethod="Delete"
InsertMethod="Insert" SelectMethod="GetDetailsByOrderID" TypeName="OrdersDataSetTableAdapters.Order_DetailsTableAdapter"
UpdateMethod="Update">
<DeleteParameters>
<asp:Parameter Name="Original_OrderID" Type="Int32" />
<asp:Parameter Name="Original_ProductID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:ControlParameter ControlID="dvOrderDetailsLinked" Name="OrderID" PropertyName="SelectedValue"
Type="Int32" />
<asp:ControlParameter ControlID="dvOrderDetailsLinked" Name="ProductID" PropertyName="SelectedValue"
Type="Int32" />
<asp:ControlParameter ControlID="dvOrderDetailsLinked" Name="Quantity" PropertyName="SelectedValue"
Type="Int16" />
<asp:ControlParameter ControlID="dvOrderDetailsLinked" Name="Discount" PropertyName="SelectedValue"
Type="Single" />
<asp:ControlParameter ControlID="dvOrderDetailsLinked" Name="Original_OrderID" PropertyName="SelectedValue"
Type="Int32" />
<asp:ControlParameter ControlID="dvOrderDetailsLinked" Name="Original_ProductID"
PropertyName="SelectedValue" Type="Int32" />
</UpdateParameters>
<SelectParameters>
<asp:QueryStringParameter DefaultValue="11077" Name="OrderID" QueryStringField="orderid"
Type="Int32" />
</SelectParameters>
<InsertParameters>
<asp:Parameter Name="OrderID" Type="Int32" />
<asp:Parameter Name="ProductID" Type="Int32" />
<asp:Parameter Name="UnitPrice" Type="Decimal" />
<asp:Parameter Name="Quantity" Type="Int16" />
<asp:Parameter Name="Discount" Type="Single" />
</InsertParameters>
</asp:ObjectDataSource>
</td>
</tr>
</table>
</div>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -