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.
0
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
0
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
0
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
0
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
0
ketan borsdiya10y ago
Hi Carlos,
Describe your problem more precisely..
Describe what is your data and output format.
I can help you.
0
Vishal Dusane10y ago
count = _db.users.GetAllAsIQueryable().Count();
if (count == 0)
{
obj.ID = 1;
}
else
{
obj.ID = count + 1;
}
0