VB 2005 & SQL

  • Thread starter Thread starter Tony K
  • Start date Start date
T

Tony K

I am trying to write a VB.NET 2005 app using a similar setup of the infamous
Northwind DB. I am using SQL 2005 Express on my laptop and will eventually
upgrade to SQL 2005.

My tables consists of:
Customers
Orders
OrderDetails
Category
Products
Suppliers

My problem is: Watching the webcasts on development using databases, they
show how to create a fully functional (yeah right) app with related tables.
They don't show how to add orders and order details related to the customer.
For example: Order Details table has a many-to-1 relationship with Orders.
I have a GUI with the cutomer info, then the related table orders, and a
group box with order details, how do I add Orders and Order Details to the
customer? The binding navigator allows me to add a user to the screen
(that's the easy part).

I guess what I want to know is what code do I need to write to add Orders
and Order Details to the customer.

The following links are pictures of my GUI for the orders form and the
related binding info for the form in VB 2005.

http://www.kingenterprises.dynu.com/images/Orders.jpg

http://www.kingenterprises.dynu.com/images/dataBinding.jpg

Thanks in advance for the help.

Tony
 
I am trying to write a VB.NET 2005 app using a similar setup of the infamous
Northwind DB. I am using SQL 2005 Express on my laptop and will eventually
upgrade to SQL 2005.

My tables consists of:
Customers
Orders
OrderDetails
Category
Products
Suppliers

My problem is: Watching the webcasts on development using databases, they
show how to create a fully functional (yeah right) app with related tables.
They don't show how to add orders and order details related to the customer.
For example: Order Details table has a many-to-1 relationship with Orders.
I have a GUI with the cutomer info, then the related table orders, and a
group box with order details, how do I add Orders and Order Details to the
customer? The binding navigator allows me to add a user to the screen
(that's the easy part).

I guess what I want to know is what code do I need to write to add Orders
and Order Details to the customer.

The following links are pictures of my GUI for the orders form and the
related binding info for the form in VB 2005.

http://www.kingenterprises.dynu.com/images/Orders.jpg

http://www.kingenterprises.dynu.com/images/dataBinding.jpg

Thanks in advance for the help.

Tony
Click to expand...


A quick google search for 'net databinding child parent relationship'
gives a few interesting results, including
http://msdn.microsoft.com/msdnmag/issues/02/02/cutting/
 
Back
Top