VB.net Programming Challenge 10-1: Inventory Management Part 1 (VB.net working with Databases)

Описание: Introduction to Programming using Visual Basic
VB.net Programming Challenge 10-1: Inventory Management Part 1 (VB.net working with Databases)

In the first part of this 3 part series we go through the project introduction, demonstrate what the program is supposed to do, and create our database connection.

The database Microland.accdb has 3 tables. The table Customers identifies each customer by an ID number and gives, in addition to the name and address the total amount of purchases during the current year prior to today.
The table Inventory identifies each product in stock by an ID number and gives, in addition to its description and price (per unit) the quantity in stock at the beginning of the day. The table Orders gives the orders received today. Suppose that it is now the end of the day. Write a program that uses the three tables to do the following:
a) Display in a list box the items that are out of stock and those that must be reordered to satisfy today's orders
b) Display in a list box bills for all customers who ordered during the day. Each bill should show the customer's name, address, items ordered (with cost), and total cost of the order.

Learning to code? Follow my VB tutorials for beginners. I do a lot of Visual Basic programming challenges and VB.net projects as part of my homework - every day!
If you are learning to program, nothing beats solving real programming exercises and coding challenges.
So don't forget to subscribe, as I release new programming videos every day!

PART 1:    • VB.net Programming Challenge 10-1: Invento...  
PART 2:    • VB.net Programming Challenge 10-1: Invento...  
PART 3:    • VB.net Programming Challenge 10-1: Invento...  

DOWNLOAD SOURCE CODE: http://www.codinghomework.com/?p=1055