VB 2005 & SQL

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
 
C

Chris Chilvers

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


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/
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top