📄 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="dsOrderQueryString" DataKeyNames="OrderID" DefaultMode="Edit" AutoGenerateRows="False" Width="326px" Height="390px">
<Fields>
<asp:BoundField ReadOnly="True" 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:SqlDataSource ID="dsOrderQueryString" Runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT [OrderID], [CustomerID], [EmployeeID], [OrderDate], [RequiredDate], [ShippedDate], [ShipVia], [Freight], [ShipName], [ShipAddress], [ShipCity], [ShipRegion], [ShipPostalCode], [ShipCountry] FROM [Orders] WHERE ([OrderID] = @OrderID)" DeleteCommand="DELETE FROM [Orders] WHERE [OrderID] = @original_OrderID" InsertCommand="INSERT INTO [Orders] ([CustomerID], [EmployeeID], [OrderDate], [RequiredDate], [ShippedDate], [ShipVia], [Freight], [ShipName], [ShipAddress], [ShipCity], [ShipRegion], [ShipPostalCode], [ShipCountry]) VALUES (@CustomerID, @EmployeeID, @OrderDate, @RequiredDate, @ShippedDate, @ShipVia, @Freight, @ShipName, @ShipAddress, @ShipCity, @ShipRegion, @ShipPostalCode, @ShipCountry)" UpdateCommand="UPDATE [Orders] SET [CustomerID] = @CustomerID, [EmployeeID] = @EmployeeID, [OrderDate] = @OrderDate, [RequiredDate] = @RequiredDate, [ShippedDate] = @ShippedDate, [ShipVia] = @ShipVia, [Freight] = @Freight, [ShipName] = @ShipName, [ShipAddress] = @ShipAddress, [ShipCity] = @ShipCity, [ShipRegion] = @ShipRegion, [ShipPostalCode] = @ShipPostalCode, [ShipCountry] = @ShipCountry 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="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="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:SqlDataSource>
</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="dsOrderDetailsLinked"
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 ReadOnly="True" HeaderText="Order ID" DataField="OrderID" SortExpression="OrderID"></asp:BoundField>
<asp:BoundField ReadOnly="True" 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:SqlDataSource ID="dsOrderDetailsLinked" Runat="server" UpdateCommand="UPDATE [Order Details] SET [UnitPrice] = @UnitPrice, [Quantity] = @Quantity, [Discount] = @Discount WHERE [OrderID] = @original_OrderID AND [ProductID] = @original_ProductID"
InsertCommand="INSERT INTO [Order Details] ([OrderID], [ProductID], [UnitPrice], [Quantity], [Discount]) VALUES (@OrderID, @ProductID, @UnitPrice, @Quantity, @Discount)"
DeleteCommand="DELETE FROM [Order Details] WHERE [OrderID] = @original_OrderID AND [ProductID] = @original_ProductID"
SelectCommand="SELECT [OrderID], [ProductID], [UnitPrice], [Quantity], [Discount] FROM [Order Details] WHERE ([OrderID] = @OrderID)"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>">
<DeleteParameters>
<asp:Parameter Type="Int32" Name="OrderID"></asp:Parameter>
<asp:Parameter Type="Int32" Name="ProductID"></asp:Parameter>
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Type="Decimal" Name="UnitPrice"></asp:Parameter>
<asp:Parameter Type="Int16" Name="Quantity"></asp:Parameter>
<asp:Parameter Type="Single" Name="Discount"></asp:Parameter>
<asp:Parameter Type="Int32" Name="OrderID"></asp:Parameter>
<asp:Parameter Type="Int32" Name="ProductID"></asp:Parameter>
</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="Single" Name="Discount"></asp:Parameter>
</InsertParameters>
</asp:SqlDataSource>
</td>
</tr>
</table>
</div>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -