How do you do a simple POS in VB .net

I need a voice of experience. I am working on a project for school. My project is a small B&M store. I am coding in VB .net I have an Access database with 3 tables - Inventory, SoldInventory and Sales. I need to create a simple POS.

I would like an experienced programmer to tell me if what I envision can be done or if I should look at something different. I have never seen any coding for a POS so I am not sure how they function.

On my form I have a datagrid, a few textboxes and 2 button. When I enter the Inventory Number in the first textbox - hit the first button. The system retrieves the appropriate record from the dataset and enters it into the datagrid. I then enter another Inventory Number and hit submit - a second record is now added to the datagrid. If I dont want an item in the datagrid - I click on that record and hit the first button - that record is now removed from the datagrid. Bascially the first button functionality is Update the datagrid.

I also have 2 more textboxes that take the price of each item and calculate tax and total sales. This information is pulled from the Price field in the datagrid.

The last button has several functions. It will print a receipt created in crystal. It will delete the chosen records from the Inventory table in Access. It will take the tax and total sales and add it to the Sales Table. It will take the information in the datagrid and add it to the SoldInventory Table. And it will clear the datagrid and dataset.

I have not figured out how to code the datagrid - I have tried several things including using the data wizard.

So the question is - Can I add one record at a time into the datagrid or am I reaching beyond Net's ability. Obviously I am reaching beyond mine :) I have googled and can not find anything.

I need a voice of experience. I am working on a project for school. My project is a small B&M store. I am coding in VB .net I have an Access database with 3 tables - Inventory, SoldInventory and Sales. I need to create a simple POS.

I would like an experienced programmer to tell me if what I envision can be done or if I should look at something different. I have never seen any coding for a POS so I am not sure how they function.

On my form I have a datagrid, a few textboxes and 2 button. When I enter the Inventory Number in the first textbox - hit the first button. The system retrieves the appropriate record from the dataset and enters it into the datagrid. I then enter another Inventory Number and hit submit - a second record is now added to the datagrid. If I dont want an item in the datagrid - I click on that record and hit the first button - that record is now removed from the datagrid. Bascially the first button functionality is Update the datagrid.

I also have 2 more textboxes that take the price of each item and calculate tax and total sales. This information is pulled from the Price field in the datagrid.

The last button has several functions. It will print a receipt created in crystal. It will delete the chosen records from the Inventory table in Access. It will take the tax and total sales and add it to the Sales Table. It will take the information in the datagrid and add it to the SoldInventory Table. And it will clear the datagrid and dataset.

I have not figured out how to code the datagrid - I have tried several things including using the data wizard.

So the question is - Can I add one record at a time into the datagrid or am I reaching beyond Net's ability. Obviously I am reaching beyond mine :) I have googled and can not find anything.

Any advice would be greatly appreciated.

Well I have solved part of this dilemma. I can bring in one record at a time into the datagrid.

DsSales1 = the dataset name.
InvItemID = the key in the table
Inventory = table Name
grdSalesView = datagrid Name
OleDbDataAdapter1 = data adapter Name
txtSKU.Text = textbox that you enter the InvItemID

I should add that I used the Wizard to add connection, adapter and dataset.

This coding works fine. Every time I enter a InvItemID into the txtSKU.text - I hit the btnSKU and the record is added to the datagrid.

I am still working on taking the prices that are listed in data grid - adding them together and putting them into Label for total price. And that last button that updates tables and prints the receipt.

Here some more of the solution: This code follows the code above - It basically grabs the data from the the datagrid in the column I specified and sends back the total. I called it subtotal because I am doing a sales application with taxes calculated.

Still trying to figure how to take the information in the datagrid and put it into a different table that is declared in the dataset. I also need to take the information in the textboxes and put that into a third table declared in the dataset.
(sigh) - I graduate next week..and I have to get this done or no Pom and Circumstance for me!

I have a 2d matrix with dimension (3, n) called A, I want to calculate the normalization and cross product of two arrays (b,z) (see the code please) for each column (for the first column, then the second one and so on).
the function that I created to find the ...

Write a C program that should create a 10 element array of random integers (0 to 9). The program should total all of the numbers in the odd positions of the array and compare them with the total of the numbers in the even positions of the array and indicate ...