Export SQL Data to Microsoft Excel (using Visual Studio 2008, c#) RRS feed

  • Question

  • User-209135589 posted

     I have list of tables in my database.

    how to retrieve list of tables including data into databound control and

    how to export the tables data to excelsheet individually.. 

    a)Gets the list of tables within the database 
    b)Gets data 
    c)Exports the data to excel worksheets (there are 2 methods defined (1) range method (2) cell by cell 
    d.) Saves the excel sheet

    plz provide the code for above requirements as soon as possible

    Wednesday, November 24, 2010 4:24 AM