Export data to excel separated by date using C# and VB.Net in ASP.Net

Question

Hi I have two table person and product I want show result each person separate by date in SQL query IdName1Ivan2Andrey3Sasha4Kolya IdIdPersonProduct  Date11oil2207201722tomato2207201633melon2207201744meat22072015 For example  out result                     IdPersonProductDateProductDate1Ivan  oil220720172Andreytomato22072016  3Sasha  milk220720174Kolyameat22072015

AnandM · Accepted Answer

Hi  FiruzI have created a sample which full fill your requirement you need to modify the code according to your needRefer below code but you cant name two column names same so you need to give columns differentlyCprotected void PageLoadobject sender EventArgs e    Bind Your DataBase Table Here    DataTable dt  new DataTable    dtColumnsAddRangenew DataColumn4  new DataColumn34Id34 new DataColumn34Person34 new DataColumn34Product34 new DataColumn34Date34     dtRowsAdd1 34Ivan34 34oil34 342207201734    dtRowsAdd2 34Andrey34 34tomato34 342207201634    dtRowsAdd3 34Sasha34 34melon34 342207201734    dtRowsAdd4 34Kolya34 34meat34 342207201534    bool nextColumn  true    DataTable dtExport  new DataTable    dtExportColumnsAddRangenew DataColumn  new DataColumn34Id34 new DataColumn34Person34 new

Export data to excel separated by date using C# and VB.Net in ASP.Net

Company

Explore

Follow us

Contact Us

Id	IdPerson	Product	Date
1	1	oil	22.07.2017
2	2	tomato	22.07.2016
3	3	melon	22.07.2017
4	4	meat	22.07.2015

Id	Person	Product	Date	Product	Date
1	Ivan			oil	22.07.2017
2	Andrey	tomato	22.07.2016
3	Sasha			milk	22.07.2017
4	Kolya	meat	22.07.2015