How to create a button to download the data from database in excel format
1. step create a button.
2. create connection with database to fetch the data.
3. add reference or install close xmal
when close xmal will be installed it will appear on your solution explorer.
now click on it
excel file is download