validatedgridview.aspx

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

								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="Freight" HeaderText="Freight"><EditItemTemplate>
									 <asp:TextBox ID="txtFreight" Runat="server" Width="52px" Text='<%# Bind("Freight") %>'></asp:TextBox>
									 <asp:RequiredFieldValidator ID="rfvFreight" Runat="server" ErrorMessage="Freight is required; enter 0 if not known."
										 Display="Dynamic" ControlToValidate="txtFreight">
										 Required!</asp:RequiredFieldValidator>
									 <asp:CustomValidator ID="cvFreight" Runat="server" ToolTip="Freight for shipped order cannot be less than $5.00"
										 ControlToValidate="txtFreight" Display="Dynamic" ErrorMessage="Freight for shipped order is less than $5.00"
										 OnServerValidate="cvFreight_ServerValidate" ClientValidationFunction="ValidateFreight">
										 <5=Bad!</asp:CustomValidator>
								 </EditItemTemplate>
									 <ItemStyle HorizontalAlign="Right" VerticalAlign="Top"></ItemStyle>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("Freight", "{0:C2}") %>' ID="lblFreight"></asp:Label>
									 </ItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="ShipName" HeaderText="Ship Name"><EditItemTemplate>
									 <asp:TextBox ID="txtShipName" Runat="server" Width="204px" Text='<%# Bind("ShipName") %>'></asp:TextBox><br />
									 <asp:RequiredFieldValidator ID="rfvShipName" Runat="server" ErrorMessage="ShipName is required."
										 Display="Dynamic" ControlToValidate="txtShipName" ToolTip="ShipName is required.">
										 ShipName is Required!</asp:RequiredFieldValidator>
								 </EditItemTemplate>
									 <ItemStyle Wrap="False" VerticalAlign="Top"></ItemStyle>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("ShipName") %>' ID="lblShipName"></asp:Label>
									 </ItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="ShipAddress" HeaderText="Ship Address"><EditItemTemplate>
									 <asp:TextBox ID="txtShipAddress" Runat="server" Width="252px" Text='<%# Bind("ShipAddress") %>'></asp:TextBox><br />
									 <asp:RequiredFieldValidator ID="rfvShipAddress" Runat="server" ErrorMessage="ShipAddress is required."
										 Display="Dynamic" ControlToValidate="txtShipAddress" ToolTip="ShipAddress is required.">
										 ShipAddress is Required!</asp:RequiredFieldValidator>
								 </EditItemTemplate>
									 <ItemStyle Wrap="False" VerticalAlign="Top"></ItemStyle>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("ShipAddress") %>' ID="lblShipAddress"></asp:Label>
									 </ItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="ShipCity" HeaderText="Ship City"><EditItemTemplate>
									 <asp:TextBox ID="txtShipCity" Runat="server" Width="116px" Text='<%# Bind("ShipCity") %>'></asp:TextBox>
									 <br />
									 <asp:RequiredFieldValidator ID="rfvShipCity" Runat="server" ToolTip="ShipCity is required."
										 ControlToValidate="txtShipCity" Display="Dynamic" ErrorMessage="ShipCity is required.">
										 ShipCity is required!</asp:RequiredFieldValidator>
								 </EditItemTemplate>
									 <ItemStyle Wrap="False" VerticalAlign="Top"></ItemStyle>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("ShipCity") %>' ID="lblShipCity"></asp:Label>
									 </ItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="ShipRegion" HeaderText="Ship Region"><EditItemTemplate>
									 <asp:TextBox ID="txtShipRegion" Runat="server" Width="108px" Text='<%# Bind("ShipRegion") %>'></asp:TextBox>
								 </EditItemTemplate>
									 <ItemStyle Wrap="False" VerticalAlign="Top"></ItemStyle>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("ShipRegion") %>' ID="lblShipRegion"></asp:Label>
									 </ItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="ShipPostalCode" HeaderText="Ship PostalCode"><EditItemTemplate>
									 <asp:TextBox ID="txtShipPostalCode" Runat="server" Width="92px" Text='<%# Bind("ShipPostalCode") %>'></asp:TextBox>
								 </EditItemTemplate>
									 <ItemStyle VerticalAlign="Top"></ItemStyle>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("ShipPostalCode") %>' ID="lblShipPostalCode"></asp:Label>
									 </ItemTemplate>
								 </asp:TemplateField>
								 <asp:TemplateField SortExpression="ShipCountry" HeaderText="Ship Country"><EditItemTemplate>
									 <asp:TextBox ID="txtShipCountry" Runat="server" Width="100px" Text='<%# Bind("ShipCountry") %>'></asp:TextBox>
									 <br />
									 <asp:RequiredFieldValidator ID="rfvShipCountry" Runat="server" ToolTip="ShipCountry is required."
										 ControlToValidate="txtShipCountry" Display="Dynamic" ErrorMessage="ShipCountry is required.">
										 ShipCountry is Required!</asp:RequiredFieldValidator>
								 </EditItemTemplate>
									 <ItemStyle Wrap="False" VerticalAlign="Top"></ItemStyle>
									 <ItemTemplate>
										 <asp:Label Runat="server" Text='<%# Bind("ShipCountry") %>' ID="lblShipCountry"></asp:Label>
									 </ItemTemplate>
								 </asp:TemplateField>
							 </Columns>
							 <SelectedRowStyle ForeColor="White" Font-Bold="True" BackColor="#008A8C"></SelectedRowStyle>
							 <RowStyle ForeColor="Black" BackColor="#EEEEEE"></RowStyle>
						 </asp:GridView>
						 <asp:SqlDataSource ID="dsOrdersEdit" Runat="server" ConnectionString="<%$ ConnectionStrings:NorthwindConnection %>"
							 SelectCommand="SELECT * FROM [Orders] ORDER BY [OrderID] DESC, [CustomerID]" 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" ConvertEmptyStringToNull=true></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>
						 <asp:SqlDataSource ID="dsEmployees" Runat="server" SelectCommand="SELECT [EmployeeID], [LastName] FROM [Employees] UNION SELECT 0, '[Last Name]' ORDER BY [LastName]"
							 ConnectionString="<%$ ConnectionStrings:NorthwindConnection %>">
						 </asp:SqlDataSource>
						 <asp:SqlDataSource ID="dsShippers" Runat="server" SelectCommand="SELECT [ShipperID], [CompanyName] FROM [Shippers] ORDER BY [CompanyName]"
							 ConnectionString="<%$ ConnectionStrings:NorthwindConnection %>">
						 </asp:SqlDataSource>
					 </td>
				 </tr>
			 </table>
		 </div>
    </div>
    </form>
</body>
</html>