Grouping excelsheet in c#

Question

i want grouping excelsheet record on the basis of id in winform application c# the example table is given below reply as soon as possible Id Name Amount A AAAA 1000 B BBBB 500 C CCCC 250 A AAAA 1500 B BBBB 1250 C CCCC 1000 A AAAA 2000 B BBBB 1750 C CCCC 1500

Upendra Pratap Shahi · Answer

Use spreadsheet gear.

Amitesh Verma · Answer

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)idname from #temp1 group by idname

Id	Name	Amount
A	AAAA	1000
B	BBBB	500
C	CCCC	250
A	AAAA	1500
B	BBBB	1250
C	CCCC	1000
A	AAAA	2000
B	BBBB	1750
C	CCCC	1500