How to export all tables from an SQL Server Database into Excel - A sheet for each table using c# asp.net?

The Answer is simple previously you done with static data, now you need to implement the same with dynamic data.

First note down the plan in one paper and proceed..

Step 1 : Whether DataBase is static one or dynamic one
Step 2 : prepare SP for getting all the tables against Database
Step 3 : Prepare select queries against each table
Step 4 : once you made query then get the result into DataSet.
Step 5 : using DataSet, you can read the data into Excel sheet.

Achieve the requirement by splitting into small small modules like above and achieve your goal.

Why do you need to do it through the code? There are perfectly good tools for exporting in most database manager programs.

Look at one of these and proceed : https://www.google.co.in/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=sql%20to%20excel%20c%23.

Come back when you stuck somewhere.