In Chapter 6 pg 222 it steps through adding a join to the select command between the Order Details and Products tables. The commandtext is updated for the join in the SelectCommand, DeleteCommand, InsertCommand, and UpdateCommand after following the steps in the book.

If you used the same 3 tables but you want the join to be between the Orders and Products tables, with the linking table as Order Details in in the middle, the joining process (steps) do not seem to work? The DeleteCommand, InsertCommand, and UpdateCommand code does not update, I assume because of a linking table. How might you recommend achieving this task of showing Orders information in Products.

If you're looking for a result similar to that from the following Northwind query, presumably with the ProductID constraint parameterized:

SELECT Orders.OrderID, Orders.CustomerID, Products.ProductID,
Products.ProductName, [Order Details].Quantity
FROM Orders INNER JOIN [Order Details] ON Orders.OrderID = [Order Details].OrderID
INNER JOIN Products ON [Order Details].ProductID = Products.ProductID
WHERE Products.ProductID = 51
ORDER BY Orders.OrderID DESC

Which returns something like the following:

11055 HILAA 51 Manjimup Dried Apples 20
11045 BOTTM 51 Manjimup Dried Apples 24
11026 FRANS 51 Manjimup Dried Apples 10
11021 QUICK 51 Manjimup Dried Apples 44
10999 OTTIK 51 Manjimup Dried Apples 15
10995 PERIC 51 Manjimup Dried Apples 20
10977 FOLKO 51 Manjimup Dried Apples 10
10965 OLDWO 51 Manjimup Dried Apples 16
...

The resultset isn't updatable. (Try pasting the query into SSMS or the Express version.) This type of query isn't amenable to drag-and-drop ("codeless") DataGridView or DataGrid generation, but you could pass a selected ProductID value from a Products grid to a dynamic SQL string or a parameterized stored procedure call to populate a grid with Orders data.

--rj