Count and display summary in asp.net+vb web from SQL Database

Baiju EP 141 Reputation points
2021-12-09T11:49:23.507+00:00

in my sql table i have following data

ID Product_Sent Sent Returned Damaged
01 Kite Red 10 08 04
02 Kite Blue 11 11 08
03 Kit Red 10 08 04
04 Kite Red 10 08 04
05 Kite Blue 11 11 08
06 Kit Red 10 08 04
07 Kit Green 5 5 3

I want result in asp.net+vb web Grid view like this

ID Product_Sent Sent Returned Damaged
01 Kite Red 40 32 16
02 Kite Blue 22 22 16
03 Kit Green 05 05 03

ASP.NET
ASP.NET
A set of technologies in the .NET Framework for building web applications and XML web services.
3,185 questions
{count} votes