How to convert the SQL server data into Excel sheet through asp.net with c# code

Posted by balajirnaukri-12656 under ASP.NET on 12/1/2011 | Points: 10 | Views : 3854 | Status : [Member] | Replies : 3
I have one table in my Sql server 2005 database I need to copy the contents of the table into an excel sheet wih an event or method through the front end in the asp.net using C# code.

Thanks and Regards
Balaji.R
ASP.NET Devloper
Solve-IT corp



Responses

Posted by: Arefin on: 12/1/2011 [Member] Starter | Points: 25

Up
0
Down
Hi,

You will get help from the below linke:
http://www.dotnetfunda.com/articles/article1150-all-in-one-export-data-in-aspnet-gridview-to-doc-gridview-to-excel-gr-.aspx

You have to fetch from SQL Server and without using GridView, just convert that data into Excel sheet.

Thanks,
Arefin

balajirnaukri-12656, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: balajirnaukri-12656 on: 12/2/2011 [Member] Starter | Points: 25

Up
0
Down
Arefin thanks a lot.Your reply was useful

Thanks and Regards
Balaji.R
ASP.NET Devloper
Solve-IT corp

balajirnaukri-12656, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Arefin on: 12/2/2011 [Member] Starter | Points: 25

Up
0
Down
Hi Balajirnaukri@gmail.com,

you are Welcome ! just click Mark As Answer, if your problem is solved :)

Thanks,
Arefin

balajirnaukri-12656, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response