Increase value of datatable cell by one depending on exception

[brendanmcdonagh]

Hi,

I have a datatable being populated in a for each loop and it's working great. I'm now trying to eradicated duplicates, I have set productid as uniques and it throws an exception when another product is added which is already present. In this exception I want to increase qty column of the already present row by 1 ....


set column[6] = column[6] + 1 where productID = exception

To basically increase the qty by 1.

Any ideas on the syntax please?

Regards

Brendan

[tlhintoq]

Personally, I wouldn't handle it that way. Instead of trying to fix after causing an error I prefer to not cause the error. In your loop check to see if the new item exists. If it does exist, don't add it (which you say is the cause of the problem)

[brendanmcdonagh]

Hi, yes I think I mised the obvious.

II have looked at a way to check if it is contained in the datatable but there doesn't seem to be a method "contains".

How would you do it? It must be done in this loop?

row = dtSearch.NewRow();
                    row["ProductID"] = p.Id;
                    String url = p.ImagePath;
                    row["ImagePath"] = ResolveUrl(url);
 
                    row["ProductName"] = p.Name;
                    row["OfferPromotion"] = p.OfferPromotion;
                    row["OfferValidity"] = p.OfferValidity;
                    row["Price"] = (decimal)p.Price;
                    row["Quantity"] = p.Quantity;
                    row["Rating"] = p.Rating;
                    dtSearch.Rows.Add(row);

[MrMancunian]

I'd check my data first, before assigning it to a new row. Put p.id in an Integer and check dtSearch in either a loop or using LINQ (in case of VS2008) to see if the key already exists. If not, create a NewRow(); and assign the values. If it does exist, it's your choice how you handle it :-)

Steven