Hi,

I wondered if someone could help with a query I have ? I've written a checkout

based web site using asp.net 1.1 and vb.net. After payment has been taken I then

want to go back and subtract the number of items purchased by the customer from

the products table within the access database.

The customer receives a summary of what items they have purchased via a datagrid.

This datagrid obtains the data from the cart items table within the database. How

do I reference the actual item (identified by the ProductID) and its quantity

within the datagrid ? I can then use this information to then subtract the

quantity value from the products table within the database. Is this the best way

to approach this ?

Any on-line examples or source code would help.

Many Thanks,

Why can't you just use the OrderID and create a function to subtract the products from inventory that way? When you grab the products for the datagrid, grab the ProductID's and the quantities and substract them then and there in the same function that is creating the datagrid.

??

rsm42: I would make verifying product quantity availability, product replenishment and product quantity sold as part of an Inventory Management Module of your business logic layer. As a Customer, if quantity ordered is NOT KNOWN or displayed prior to product selection, it very well better be known by checkout. When the Invoice is printed with "the count and amount", as a Customer, that is what I expect to receive and pay. Then how are partial orders, aback orders and return orders or products(Return Authorization Process) handled? All should be processed in the Inventory Management Module.

Hope this helps.

rsm42: I more thing I would like to add to my previous reply:
  Each Order is a DataTable which Binds to a Datagrid and as a DataTable using the DataRow and DataColumn, one can extract the productID and Quantity to calulate the product cost and decrement the quantity in inventory after the customer accepts the invoice for payment.