LINQ Update a New Column uisng LINQ Part 10
(From row In dtMonthlyTable
Let a = row("Item Description").Tostring
Let b = row("Quantity").ToString
Let c =row("Price").Tostring
Let x = New Object(){a, b, If(a.Contains("Rice"), (CInt(c)*2).ToString , c), String.Concat(a,"has a quantity of " ,b,"with price as ",c) }
Select dtOutputTable.Rows.Add(x)).copytodatatable