how to count if id > greater than 1

Carlos kambui

am generating sales summarry where by i have ,product_id, Description and qnty now i want if product_id > 1 it add to qnty

urgent one pliz i.e product_id(1,2,2,3,4,5,2,6,) the qnty to be 3

urgent one pliz

7 Replies

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

ketan borsdiya10y ago
are use for each OR for loop in code?
If yes then provide whole code snippet.
Carlos kambui10y ago
with that it add qnty column to be two for every item of which i want only item that it qnty is more than one
ketan borsdiya10y ago
Hi,

check what is the data type of trans_quantity? If it is string then you have to convert it in int.

OR

Replace item.trans_quantity = +1 with item.trans_quantity =Convert.ToInt32(item.trans_quantity) + 1
Carlos kambui10y ago
i want to print sales summary for a day i can only retrieve one by one whereby i want if sugar were 10kg and product_id for sugar is 100 i can only be able to retrieve 11111.... ten times of which i want qnty column for sugar to be 10
Carlos kambui10y ago
Dim productid As Integer = item.location_product_id
Dim xcount1 As Integer = 1
If item.location_product_id > 1 Then
item.trans_quantity = +1
Rectify the above codes for me pliz
ketan borsdiya10y ago
Hi Carlos,
Describe your problem more precisely..
Describe what is your data and output format.
I can help you.
Vishal Dusane10y ago
count = _db.users.GetAllAsIQueryable().Count();
if (count == 0)
{
obj.ID = 1;
}
else
{
obj.ID = count + 1;
}