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

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

Answers

Grouping excelsheet in c#

Farooque Khan

722

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

Answers (2)

Next Recommended Forum

Text Box event for Barcode Scanner using Windows Application

DataGridView cell Empty

Leaderboard

View all

Rodrigo Diaz

+13

Tuhin Paul

George

View all

Yesterday's leader

Rodrigo Diaz

Software Architecture, Cloud computing, Cloud-native apps, AI, .NET, C#

Mexico

173

13.1k

11k

500

Member of the month

Mark Pelf

Belgrade (Yugoslavia)

187

289.8k

10.5k

500

Speaker of the month

Magnus Mårtensson

ASP.NET, .NET, C#, JavaScript, Azure

Sweden

18.5k

58.5k

Upcoming events

View all

Suggested for you

View all

Kanchana Jayathilake

Kirtesh Shah

Vignesh Kumar

David Mccarter

Adarsh Nigam

Forum Statistics

Please welcome our newest member Vibooshan S .
3,077,501 users have contributed to 147,418 threads and 483,387
In the past 24 hours, we have 5 new threads, 30 new posts, and 96 new users.
In last week, the most popular thread is 'Saving multiple choices as single rows'.