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

Question

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

Rafnas T P · 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

Ramesh Palanivel · Answer

Hi Rafnas She want to group the products whatever repeated again. She want total count instead of showing differ count.

Jyoti Jodha · Answer

yes I want to Update within same date or insert as a new records

Rafnas T P · Answer

do you wanted to update within same date or insert as a new record

Rafnas T P · Answer

hi can you tell me what is your real requirment

Ravi Sangtani · Answer

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).

Ramesh Palanivel · Answer

you can use group by option.try it..

Jyoti Jodha · Answer

In Inventory Table same Name item save in different Date how to update Inventory Table

Ramesh Palanivel · Answer

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