I am new to VB. Currently i am doing a Stock manage program with VB and SQL 2008.
When Receive new stock from Supplier,I put recive item in a winform with DataGrid view. some thing like this
**Item Description Received Qty UnitPrice Total**
1001 Acer Laptop 10 455 4550
1005 Monitor 20 100 2000
this data insert to purchase details table and I have another table for Stock call Stock.
now I want to do when after enter the data and when click save button ReceiveQty value add to CurrentStock colunm in Stock table.
in this case how can i do this. I hope you could understand what i try to do here.
if you want to see my code I can past here.
Thanks all!