i want to upload my excel sheet on button click and save in sql database.
what part are you having trouble with.
1) upload files?
https://docs.microsoft.com/en-us/aspnet/core/mvc/models/file-uploads?view=aspnetcore-3.1
2) save file to database? just use byte[] as the column type.
3) use sqlserver file tables?
https://damienbod.com/2015/12/05/asp-net-5-mvc-6-file-upload-with-ms-sql-server-filetable/
Hi rritesh1990,
What is the version of your Project?And did you want to use asp.net core mvc or asp.net core razor pages?
Did you think of using EPPlus?
Here is a simple tutorial as below:
https://www.c-sharpcorner.com/article/import-and-export-data-using-epplus-core/
Best Regards,
Rena
