How to Add same product name Qty in window application c#

Jyoti Jodha

Inventory Table

Item in Stock

How to add two same name item like cello (50+40=90) and notebook (30+80=110)

sum(cast(inv.QTY as numeric(18,2)))+isnull(sum(cast(inv.QTY as numeric(18,2))),0) as totalQty

9 Replies

Know the answer? Post it — somebody with the same question will find it here.

Rafnas T P9y ago
Accepted answer
if you want to store inventory record then you should not update existing record, you have to insert new records in order to track previous stock,
0
Ramesh Palanivel9y ago
Hi Rafnas, She want to group the products whatever repeated again. She want total count instead of showing differ count.
0
Jyoti Jodha9y ago
yes ,I want to Update within same date or insert as a new records
0
Rafnas T P9y ago
do you wanted to update within same date or
insert as a new record
0
Rafnas T P9y ago
hi,
can you tell me what is your real requirment
0
Ravi Sangtani9y ago
Hi Jyoti

You have to insert different record but when you show data or select records you have to group by unit in your query with sum(totalQty).
0
Ramesh Palanivel9y ago
you can use group by option.try it..
0
Jyoti Jodha9y ago
In Inventory Table same Name item save in different Date

how to update Inventory Table
0
Ramesh Palanivel9y ago
Hi Jyothi,

In Inventory table, if the item is new add it in your inventory table, if it is already exists, update it....
0