validateddetailsview.aspx

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

									 </ItemTemplate>
									 <InsertItemTemplate>
										 <asp:TextBox Runat="server" Text='<%# Bind("ShippedDate", "{0:d}") %>' ID="txtInsertShippedDate" Width="80px"></asp:TextBox>
									 </InsertItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="ShipVia" HeaderText="Ship Via"><EditItemTemplate>
									 <asp:TextBox Runat="server" Text='<%# Bind("ShipVia") %>' ID="txtEditShipVia" Width="20px"></asp:TextBox>
									 <asp:RequiredFieldValidator ID="revEditEmployeeID" Runat="server" ToolTip="ShipVia is a required field."
										 Display="Dynamic" ControlToValidate="txtEditShipVia" ErrorMessage="ShipVia is a required field.">
										 Required Field</asp:RequiredFieldValidator>
									 <asp:RangeValidator ID="rvEditShipVia" Runat="server" ToolTip="ShipVia must be 1, 2 or 3."
										 ControlToValidate="txtEditShipVia" ErrorMessage="ShipVia must be 1, 2 or 3." MaximumValue="3"
										 MinimumValue="1" Type="Integer">
										 1, 2 or 3 is Valid</asp:RangeValidator>
								 </EditItemTemplate>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("ShipVia") %>' ID="lblEditShipVia"></asp:Label>
									 </ItemTemplate>
									 <InsertItemTemplate>
										 <asp:TextBox Runat="server" Text='<%# Bind("ShipVia") %>' ID="txtInsertShipVia" Width="20px"></asp:TextBox>
										 <asp:RequiredFieldValidator ID="rfvInsertShipVia" Runat="server" ToolTip="ShipVia is a required field."
											 Display="Dynamic" ControlToValidate="txtInsertShipVia" ErrorMessage="ShipVia is a required field.">
											 Required Field</asp:RequiredFieldValidator><asp:RangeValidator ID="rvInsertShipVia"
												 Runat="server" ToolTip="ShipVia must be 1, 2 or 3." ControlToValidate="txtInsertShipVia"
												 ErrorMessage="ShipVia must be 1, 2 or 3." MaximumValue="3" MinimumValue="1" Type="Integer">
												 1, 2 or 3 is Valid</asp:RangeValidator>
									 </InsertItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="Freight" HeaderText="Freight"><EditItemTemplate>
									 <asp:TextBox Runat="server" Text='<%# Bind("Freight") %>' ID="txtEditFreight" Width="50px"></asp:TextBox>
									 <asp:RequiredFieldValidator ID="rfvEditFreight" Runat="server" ToolTip="Freight amount is required; enter 0 if unknown."
										 Display="Dynamic" ControlToValidate="txtEditFreight" ErrorMessage="Freight amount is required.">
										 Required Field</asp:RequiredFieldValidator>
								 </EditItemTemplate>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("Freight", "{0:c}") %>' ID="lblEditFreight"></asp:Label>
									 </ItemTemplate>
									 <InsertItemTemplate>
										 <asp:TextBox Runat="server" Text='<%# Bind("Freight") %>' ID="txtInsertFreight" Width="50px"></asp:TextBox>
										 <asp:RequiredFieldValidator ID="rfvInsertFreight" Runat="server" ToolTip="Freight amount is required; enter 0 if unknown."
											 Display="Dynamic" ControlToValidate="txtInsertFreight" ErrorMessage="Freight amount is required.">
											 Required Field</asp:RequiredFieldValidator>
									 </InsertItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="ShipName" HeaderText="Ship Name"><EditItemTemplate>
									 <asp:TextBox Runat="server" Text='<%# Bind("ShipName") %>' ID="txtEditShipName"></asp:TextBox>
								 </EditItemTemplate>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("ShipName") %>' ID="lblEditShipName"></asp:Label>
									 </ItemTemplate>
									 <InsertItemTemplate>
										 <asp:TextBox Runat="server" Text='<%# Bind("ShipName") %>' ID="txtInsertShipName"></asp:TextBox>
									 </InsertItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="ShipAddress" HeaderText="Ship Address"><EditItemTemplate>
									 <asp:TextBox Runat="server" Text='<%# Bind("ShipAddress") %>' ID="txtEditShipAddress"></asp:TextBox>
								 </EditItemTemplate>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("ShipAddress") %>' ID="lblEditShipAddress"></asp:Label>
									 </ItemTemplate>
									 <InsertItemTemplate>
										 <asp:TextBox Runat="server" Text='<%# Bind("ShipAddress") %>' ID="txtInsertShipAddress"></asp:TextBox>
									 </InsertItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="ShipCity" HeaderText="Ship City"><EditItemTemplate>
									 <asp:TextBox Runat="server" Text='<%# Bind("ShipCity") %>' ID="txtEditShipCity"></asp:TextBox>
								 </EditItemTemplate>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("ShipCity") %>' ID="lblEditShipCity"></asp:Label>
									 </ItemTemplate>
									 <InsertItemTemplate>
										 <asp:TextBox Runat="server" Text='<%# Bind("ShipCity") %>' ID="txtInsertShipCity"></asp:TextBox>
									 </InsertItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="ShipRegion" HeaderText="Ship Region"><EditItemTemplate>
									 <asp:TextBox Runat="server" Text='<%# Bind("ShipRegion") %>' ID="txtEditShipRegion"></asp:TextBox>
								 </EditItemTemplate>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("ShipRegion") %>' ID="lblEditShipRegion"></asp:Label>
									 </ItemTemplate>
									 <InsertItemTemplate>
										 <asp:TextBox Runat="server" Text='<%# Bind("ShipRegion") %>' ID="txtInsertShipRegion"></asp:TextBox>
									 </InsertItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="ShipPostalCode" HeaderText="Ship PostalCode"><EditItemTemplate>
									 <asp:TextBox Runat="server" Text='<%# Bind("ShipPostalCode") %>' ID="txtEditShipPostalCode"></asp:TextBox>
								 </EditItemTemplate>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("ShipPostalCode") %>' ID="lblEditShipPostalCode"></asp:Label>
									 </ItemTemplate>
									 <InsertItemTemplate>
										 <asp:TextBox Runat="server" Text='<%# Bind("ShipPostalCode") %>' ID="txtInsertShipPostalCode"></asp:TextBox>
									 </InsertItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="ShipCountry" HeaderText="Ship Country"><EditItemTemplate>
									 <asp:TextBox Runat="server" Text='<%# Bind("ShipCountry") %>' ID="txtEditShipCountry"></asp:TextBox>
								 </EditItemTemplate>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("ShipCountry") %>' ID="lblEditShipCountry"></asp:Label>
									 </ItemTemplate>
									 <InsertItemTemplate>
										 <asp:TextBox Runat="server" Text='<%# Bind("ShipCountry") %>' ID="txtInsertShipCountry"></asp:TextBox>
									 </InsertItemTemplate>
								 </asp:TemplateField>
								 <asp:CommandField ShowInsertButton="True" ShowEditButton="True"></asp:CommandField>
							 </Fields>
						 </asp:DetailsView>
					 </td>
					 <td valign="top" style="width: 320px; height: 21px">
						 <asp:GridView ID="gvOrderDetails" Runat="server" DataSourceID="dsNWOrderDetailsFiltered"
							 DataKeyNames="OrderID,ProductID" AutoGenerateColumns="False" Font-Names="Verdana" Font-Size="10pt" CaptionAlign="Left" >
							 <Columns>
								 <asp:CommandField ShowEditButton="True"></asp:CommandField>
								 <asp:TemplateField SortExpression="OrderID" HeaderText="Order ID"><ItemTemplate>
									 <asp:Label Runat="server" Text='<%# Bind("OrderID") %>' ID="lblOrderID"></asp:Label>
								 </ItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField HeaderText="Prod. ID"><EditItemTemplate>
									 <asp:TextBox ID="txtProductID" Runat="server" Width="24px" Text='<%# Bind("ProductID") %>'></asp:TextBox>
									 <asp:RequiredFieldValidator ID="rfvProductID" Runat="server" ToolTip="ProductID is required."
										 Display="Dynamic" ControlToValidate="txtProductID" ErrorMessage="ProductID is required.">
										 Req!</asp:RequiredFieldValidator>
									 <asp:RangeValidator ID="rvProductID" Runat="server" ToolTip="ProductID range is 1 to 77."
										 Display="Dynamic" ControlToValidate="txtProductID" ErrorMessage="ProductID range is 1 to 77."
										 Type="Integer" MinimumValue="1" MaximumValue="77">
										 1-77</asp:RangeValidator>
									 <asp:CustomValidator ID="cvProductID" Runat="server" ToolTip="Duplicates existing ProductID."
										 ErrorMessage="Duplicates existing ProductID." ControlToValidate="txtProductID"
										 Display="Dynamic" OnServerValidate="cvProductID_ServerValidate" ClientValidationFunction="ValidateProductID">
										 Dup!</asp:CustomValidator>
								 </EditItemTemplate>
									 <ItemTemplate>
										 <asp:Label ID="lblProductID" Runat="server" Text='<%# Bind("ProductID") %>'></asp:Label>
									 </ItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="Quantity" HeaderText="Quan."><EditItemTemplate>
									 <asp:TextBox ID="txtQuantity" Runat="server" Width="20px" Text='<%# Bind("Quantity") %>'></asp:TextBox>
									 <asp:RequiredFieldValidator ID="rfvQuantity" Runat="server" ErrorMessage="Quantity is required."
										 ControlToValidate="txtQuantity" Display="Dynamic" ValidationGroup="Quantity is required.">
										 Req!</asp:RequiredFieldValidator>
									 <asp:RangeValidator ID="rvQuantity" Runat="server" ToolTip="Quantity must be 1 or greater."
										 ErrorMessage="Quantity must be 1 or greater." ControlToValidate="txtQuantity"
										 Display="Dynamic" MaximumValue="500" MinimumValue="1" Type="Integer">
										 Min. 1</asp:RangeValidator>
								 </EditItemTemplate>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("Quantity") %>' ID="lblQuantity"></asp:Label>
									 </ItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField HeaderText="Unit Price"><EditItemTemplate>
									 <asp:TextBox ID="txtUnitPrice" Runat="server" Width="48px" Text='<%# Bind("UnitPrice") %>'></asp:TextBox>