Today we learn how export the data from the database into
Microsoft excel sheet. So many
techniques or ways to export the data into Microsoft excel sheet, but here I have
tried to use the easiest way for this purpose or task. No extra namespace,
class our assemblies are not required for it. Just follow few steps and get the
data on the excel sheet.
We will work step by step
- First step is to create the database and insert the values in it.
- Now add the Dataset into the project. And create a query in it that gets the data from the database table.
- Now go to the .CS page and write the code for it.
Bellow is step by step Example for this task.
