Hello All,
Just starting out with VB2005 using SQL2005 Express, I hope that someone may
be able to help me, I have created a windows application and have created a
connection to the sql database (Northwind) and added the required tables to
the data sources using the wizard, I have dragged the 'Customers table' (as
Details) onto the form as well as the 'Orders' and 'Order Details' Tables
(as Datagridview's) onto the same form, I have then added an additional
binding navigator (datasource set to FKOrdersCustomersBindingSource). I have
set the datasource for the Orders Datagridview to the
FKOrdersCustomersBindingSource and the Order Details Datagridview to
FKOrderDetailsOrdersBindingSource. My problem is that although the two
binding navigators work as expected the Order Details Datagridview fails to
display the correct data almost as though it isn't bound to anything, I know
that I must be overlooking something but I can't work it out.
Is there someone who would be able to point me in the right direction ?
Thanks
Dave.
Real_Foggy - 22 Jan 2007 07:08 GMT
Doh....
Just realised where I went wrong, after re-reading the book for the
umpteenth time, I should have dragged the tables from the same node.
Thanks & regards
Dave.
> Hello All,
>
[quoted text clipped - 19 lines]
>
> Dave.