Like the following example: id quantity Bonus price total 01 25 10 123 4305 01 5 10 123 1845 I want to sum of the above two rows like this in the DataGrid. id quantity Bonus price total 01 30 20 246 6150
SELECT id, SUM(quantity) AS quantity, SUM(Bonus) AS Bonus, SUM(price) AS price, SUM(total) AS total FROM YourTableName GROUP BY id
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)