Grouping excelsheet in c#

create table #temp1(id varchar(1),name varchar(20),amount int)
insert into #temp1 values('A','ABC',3200)
insert into #temp1 values('B','ABBB',7800)
insert into #temp1 values('A','ABC',2000)
insert into #temp1 values('A','ABC',1200)
insert into #temp1 values('C','AAAA',2000)
insert into #temp1 values('C','AAAA',5000)
SELECT * FROM #temp1

select SUM(amount),id,name from #temp1 group by id,name