multipal seet data save in data base

Question

How to multipal seet data uplode and downlode in data base.

Manas Mohapatra · Answer

First read data from multiple sheets in excel file. Follow below link: http://www.c-sharpcorner.com/UploadFile/a20beb/get-data-from-multiple-sheets-of-excel-in-Asp-Net-web-applic/ http://www.c-sharpcorner.com/UploadFile/00a8b7/dealing-with-excel-sheets295/ Next save the data into database whatever datas you read from excel file. You can save it normal way or you can use SqlBulkCopy class. http://www.c-sharpcorner.com/blogs/bulk-copy-in-sql-server-using-c-sharpnet1 Next you need to read from database and write to excelsheet. http://www.c-sharpcorner.com/blogs/generate-excel-with-multiple-sheet-from-dataset1 https://www.codementor.io/tips/2415380713/how-to-create-excel-file-with-multiple-sheets-from-dataset-using-c http://www.dotnetfunda.com/articles/show/3114/how-to-create-multiple-sheets-into-ms-excel-programmatically-in-csharp

pallavi singhal · Answer

Thankyou Manas I will use this and update the status. Regards Pallavi Singhal

pallavi singhal · Answer

how to excel file multiple sheet data uplode on one click save in data base server and downlode?

Manas Mohapatra · Answer

Please describe more what is your exact requirement...