Export multiple table record using join query to Excel and merge duplicate rows using C# and VB.Net in ASP.Net

Question

Hi I have three table Person  fruits and boughttableIdName1Rustam2Firuz3Asror4Nurullo IdName1Apple2Orange3Cherry4Limon5Apricot IdPersonIdFruitId112211323425513615724822933103511411244 Using AspNet show result in excel For exampleIdNameFruits1RustamApple2 Orange3 Cherry4 Apricot5FiruzOrange6 Cherry7 Limon8 Apricot9AsrorLimon10 Apricot

Indresh · Accepted Answer

Hi  PRAPlease refer the below code You need to get the result using join query to datatableCprotected void PageLoadobject sender EventArgs e    if IsPostBack            DataTable dt  new DataTable        dtColumnsAdd34Id34        dtColumnsAdd34Name34        dtColumnsAdd34Fruits34        dtRowsAdd34134 34Rustam34 34Apple34        dtRowsAdd34234 34Rustam34 34Orange34        dtRowsAdd34334 34Rustam34 34Cherry34        dtRowsAdd34434 34Rustam34 34Apricot34        dtRowsAdd34534 34Firuz34 34Orange34        dtRowsAdd34634 34Firuz34 34Cherry34        dtRowsAdd34734 34Firuz34 34Limon34        dtRowsAdd34834 34Firuz34 34Apricot34        dtRowsAdd34934 34Asror34 34Limon34        dtRowsAdd341034 34Asror34 34

Export multiple table record using join query to Excel and merge duplicate rows using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us

Id	Name	Fruits
1	Rustam	Apple
2		Orange
3		Cherry
4		Apricot
5	Firuz	Orange
6		Cherry
7		Limon
8		Apricot
9	Asror	Limon
10		Apricot

Id	PersonId	FruitId
1	1	2
2	1	1
3	2	3
4	2	5
5	1	3
6	1	5
7	2	4
8	2	2
9	3	3
10	3	5
11	4	1
12	4	4