validateddetailsview.aspx

wrox出版社的另一套经典的VB2005数据库编程学习书籍,收集了书中源码,郑重推荐,电子书,电子书下载

									 <asp:RequiredFieldValidator ID="rfvUnitPrice" Runat="server" ToolTip="UnitPrice is required and must be $1.00 or greater."
										 ErrorMessage="UnitPrice is required and must be $1.00 or greater." ControlToValidate="txtUnitPrice"
										 Display="Dynamic">
										 Req!</asp:RequiredFieldValidator>
									 <asp:RangeValidator ID="rvUnitPrice" Runat="server" ToolTip="UnitPrice must be $1.00 or greater."
										 ErrorMessage="UnitPrice must be $1.00 or greater." ControlToValidate="txtUnitPrice"
										 Type="Currency" Display="Dynamic" MaximumValue="5000" MinimumValue="1">
										 >=1</asp:RangeValidator>
								 </EditItemTemplate>
									 <ItemTemplate>
										 <asp:Label ID="lblUnitPrice" Runat="server" Text='<%# Bind("UnitPrice", "{0:c}") %>'></asp:TextBox> "> <asp:TextBox ID="txtUnitPrice" Runat="server" Width="48px" Text='<%# Bind("UnitPrice") %>'></asp:TextBox> </SPAN></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR><TR style="HEIGHT: 1px"><TD style="FONT-SIZE: 0pt"></TD></TR><TR><TD><TABLE style="BORDER-RIGHT: buttonface 1px solid; BORDER-TOP: buttonface 1px solid; BORDER-LEFT: buttonface 1px solid; BORDER-BOTTOM: buttonface 1px solid" height="100%" cellSpacing=0 cellPadding=2 width="100%" border=0><TR style="FONT: messagebox; COLOR: buttonshadow; BACKGROUND-COLOR: buttonface"><TD style="FONT-WEIGHT: normal; FONT-SIZE: 8.25pt; COLOR: #808080; FONT-STYLE: normal; FONT-FAMILY: Tahoma; BACKGROUND-COLOR: buttonface; TEXT-DECORATION: none" height=20>&nbsp;HeaderTemplate&nbsp;&nbsp;&nbsp; </TD></TR><TR><TD><TABLE height="100%" cellSpacing=0 cellPadding=0 width="100%" border=0><TR><TD style="FONT-SIZE: 10pt; FONT-FAMILY: 'Verdana'; HEIGHT: 50px"><SPAN isWatermark webControlRegionIndex=3 ignoreParentFrozen title="HeaderTemplate - Click to start editing." contentEditable=true style="DISPLAY: inline-block; BEHAVIOR: url(#default#ControlRegion); WIDTH: 100%; HEIGHT: 100%" watermarkText="To edit this template, click here and type text or drag a control from the Toolbox."></SPAN></TD></TR></TABLE></TD></TR></TABLE></TD></TR><TR style="HEIGHT: 1px"><TD style="FONT-SIZE: 0pt"></TD></TR><TR><TD><TABLE style="BORDER-RIGHT: buttonface 1px solid; BORDER-TOP: buttonface 1px solid; BORDER-LEFT: buttonface 1px solid; BORDER-BOTTOM: buttonface 1px solid" height="100%" cellSpacing=0 cellPadding=2 width="100%" border=0><TR style="FONT: messagebox; COLOR: buttonshadow; BACKGROUND-COLOR: buttonface"><TD style="FONT-WEIGHT: normal; FONT-SIZE: 8.25pt; COLOR: #808080; FONT-STYLE: normal; FONT-FAMILY: Tahoma; BACKGROUND-COLOR: buttonface; TEXT-DECORATION: none" height=20>&nbsp;FooterTemplate&nbsp;&nbsp;&nbsp; </TD></TR><TR><TD><TABLE height="100%" cellSpacing=0 cellPadding=0 width="100%" border=0><TR><TD style="FONT-SIZE: 10pt; FONT-FAMILY: 'Verdana'; HEIGHT: 50px"><SPAN isWatermark webControlRegionIndex=4 ignoreParentFrozen title="FooterTemplate - Click to start editing." contentEditable=true style="DISPLAY: inline-block; BEHAVIOR: url(#default#ControlRegion); WIDTH: 100%; HEIGHT: 100%" watermarkText="To edit this template, click here and type text or drag a control from the Toolbox."></SPAN></TD></TR></TABLE></TD></TR></TABLE></TD></TR></TBODY></TABLE></asp:Label>
									 </ItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="Discount" HeaderText="Disc."><EditItemTemplate>
									 <asp:TextBox ID="txtDiscount" Runat="server" Width="40px" Text='<%# Bind("Discount") %>'></asp:TextBox>
									 <asp:RequiredFieldValidator ID="rfvDiscount" Runat="server" ToolTip="Discount is required (0 if none)."
										 ErrorMessage="Discount is required (0 if none)." ControlToValidate="txtDiscount"
										 Display="Dynamic">
										 Req.</asp:RequiredFieldValidator>
								 </EditItemTemplate>
									 <ItemStyle Wrap="False"></ItemStyle>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("Discount", "{0:p1}") %>' ID="lblDiscount"></asp:Label>
									 </ItemTemplate>
								 </asp:TemplateField>
							 </Columns>
						 </asp:GridView><br />
						 <asp:DetailsView ID="dvOrderDetails" Runat="server" Font-Size="10pt" Font-Names="Verdana"
							 Width="255px" Height="142px" AllowPaging="True" AutoGenerateRows="False" DataSourceID="dsNWOrderDetailsView"
							 DataKeyNames="OrderID,ProductID">
							 <Fields>
								 <asp:BoundField ReadOnly="True" HeaderText="Order ID" DataField="OrderID" NullDisplayText="Generated"
									 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:p1}"></asp:BoundField>
								 <asp:CommandField ShowDeleteButton="True" ShowInsertButton="True" ShowEditButton="True"></asp:CommandField>
							 </Fields>
						 </asp:DetailsView>
						 <!-- See modified UpdateCommand below
						 Original: UpdateCommand="UPDATE [Order Details] SET [UnitPrice] = @UnitPrice, [Quantity] = @Quantity, [Discount] = @Discount WHERE [OrderID] = @original_OrderID AND [ProductID] = @original_ProductID"> -->
						 <asp:SqlDataSource ID="dsNWOrderDetailsView" Runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnection %>"
							 SelectCommand="SELECT [OrderID], [ProductID], [UnitPrice], [Quantity], [Discount] FROM [Order Details] WHERE ([OrderID] = @OrderID)" DeleteCommand="DELETE FROM [Order Details] WHERE [OrderID] = @original_OrderID AND [ProductID] = @original_ProductID"
							 InsertCommand="INSERT INTO [Order Details] ([OrderID], [ProductID], [UnitPrice], [Quantity], [Discount]) VALUES (@OrderID, @ProductID, @UnitPrice, @Quantity, @Discount)"
							 UpdateCommand="UPDATE [Order Details] SET [UnitPrice] = @UnitPrice, [Quantity] = @Quantity, [Discount] = @Discount WHERE [OrderID] = @original_OrderID AND [ProductID] = @original_ProductID">
							 <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:ControlParameter Name="OrderID" DefaultValue="11077" Type="Int32" ControlID="dvOrders"
									 PropertyName="SelectedValue"></asp:ControlParameter>
							 </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>
			 &nbsp;
			 <asp:SqlDataSource ID="dsNWOrdersDetails" Runat="server"
							 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"
							 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)"
							 DeleteCommand="DELETE FROM [Orders] WHERE [OrderID] = @original_OrderID"
							 SelectCommand="SELECT * FROM [Orders] ORDER BY [OrderID] DESC, [CustomerID]" ConnectionString="<%$ ConnectionStrings:NorthwindConnection %>">
							 <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>
							 <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>&nbsp;
			 <!-- See modified UpdateCommand below
			 Original: UpdateCommand="UPDATE [Order Details] SET [UnitPrice] = @UnitPrice, [Quantity] = @Quantity, [Discount] = @Discount WHERE [OrderID] = @original_OrderID AND [ProductID] = @original_ProductID" -->
			 <asp:SqlDataSource ID="dsNWOrderDetailsFiltered" Runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnection %>"
				 SelectCommand="SELECT * FROM [Order Details] WHERE ([OrderID] = @OrderID)" 
				 DeleteCommand="DELETE FROM [Order Details] WHERE [OrderID] = @original_OrderID AND [ProductID] = @original_ProductID" 
				 InsertCommand="INSERT INTO [Order Details] ([OrderID], [ProductID], [UnitPrice], [Quantity], [Discount]) VALUES (@OrderID, @ProductID, @UnitPrice, @Quantity, @Discount)" 
				 UpdateCommand="UPDATE [Order Details] SET [ProductID] = @ProductID, [UnitPrice] = @UnitPrice, [Quantity] = @Quantity, [Discount] = @Discount WHERE [OrderID] = @original_OrderID AND [ProductID] = @original_ProductID">
				 <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:ControlParameter Name="OrderID" Type="Int32" ControlID="dvOrders" PropertyName="SelectedValue"></asp:ControlParameter>
				 </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>
		 </div>
    </div>
    </form>
</body>
</html>