How to get product balance?
I am new in C# and SQL, I have 3 tables Products, Purchase and Sale.
In Purchase and Sale tables ProductId and Quantity is saved.
I want to fill Datagridview as below:
Product Id Purchase Qty, Sale Qty, Balance Qty
In my table Product there are 10000 products saved and Purchase records
are 25000 and Sale records are 20000.
I am trying to calculate from C# but it taking a 5 to 10 minutes to fill.
No comments:
Post a Comment