linkeddetailsview.aspx

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

                                     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>
                         &nbsp;
					 </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: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>
                         <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>