I'm working on a VB.Net Project. I'm using MS SQL Server as my backend.
I can create Purchase/Sales Voucher forms and many more through the VB.Net Database EXpress.
Say for example I have created a Purchase Voucher form where the user can enter the vendor info (in TextBox view) as well as the the Product, Quantity, Rate , Totals (in Datagridview). thus the user can save the purchase voucher to the database as for record.
BUT THE PROBLEM IS THAT I also want that when the user enters the Product, Quantity, Rate, etc. the stock also get increased (updated) automatically.
IN THIS CASE I NEED YOUR 'VALUABLE SOLUTION'