Exporting data from database to excel sheet without use of gridview

Question

i want that when i click a button the data from particular table(including table header) should import to excel sheet and excel should save on solution explore folder excel.
i dont want to use any data grid like grid view or any thing.
how i can achieve this

Ankit Shivnakr · Answer

Hi Please Find Attachment for Your solution and make change according to ur need

Satyapriya Nayak · Answer

Hi Nishant Please refer the below link http://www.codeproject.com/KB/aspnet/coolcode2_aspx.aspx Thanks

Mukesh Kumar · Answer

hi Check this link http://blog.sqlauthority.com/2008/01/08/sql-server-2005-export-data-from-sql-server-2005-to-microsoft-excel-datasheet/