How to Import Data from Excel File to Database Table Using ASP.NET Core and Entity Framework

Рет қаралды 9,157

Күн бұрын

Import Data from Excel File to Database Table Using ASP.NET Core 7 and Entity Framework
0:00 - Introduction
1:45 - Installing Packages
3:32 - Database Configuration
8:44 - Running Migrations
12:22 - Creating View and Uploading File
17:21 - Installing 'ExcelDataReader' Package
18:48 - Insert Data in Database
22:44 - Showing Success Message/Alert
BuyMeCoffee
www.buymeacoffee.com/techiebo...
Github
github.com/dexcodelab/ExcelTo...
In this tutorial, I have shown the process of importing data from an Excel file into a MS SQL Server Database table using ASP.NET Core 7 and Entity Framework. I have explained things step-by-step so that if you follow me along you get the same result. Please do like the video and subscribe to my channel. If you like my video you can support me by buying me a coffee.

Пікірлер: 44

@olegpogorelov5223 5 ай бұрын

Thank you very much! Finally, thanks to your video tutorial, I understood this topic!)

@dexcodelab 4 ай бұрын

You're welcome. Glad it helped!

@namessis Ай бұрын

Amazing thanks for your labor and solution. !!! We are excitedly waiting for content.

@dexcodelab Ай бұрын

Thankyou for liking the content, will try to upload more helpful content in future

@CyberCopgyan Ай бұрын

Thanku bro this solution is best one

@dexcodelab Ай бұрын

You're welcome

@juliuszhu9123 2 ай бұрын

nice job! thanks for doing this.

@dexcodelab 2 ай бұрын

My pleasure!

@ekremozafsar2875 7 ай бұрын

Thank u man keep going!

@dexcodelab 7 ай бұрын

You're welcome

@hieuang79 3 ай бұрын

Thank you very much!

@dexcodelab 3 ай бұрын

You're welcome sir

@pamodpeiris154 2 ай бұрын

Very good explanation. Short and clear.

@dexcodelab 2 ай бұрын

Glad you liked it

@hoangheo2505 8 ай бұрын

thanks you for tutorial ^^

@dexcodelab 7 ай бұрын

You're welcome 😊

@bipinlal1724 4 ай бұрын

Very good video, really understood. data can be saved very 👍👍👍👍

@dexcodelab 4 ай бұрын

Thank you sir

@myti1617 3 ай бұрын

that was perfect

@dexcodelab 3 ай бұрын

Thankyou sir

@raziuddinmohd 9 ай бұрын

Nice explanation..very useful

@dexcodelab 9 ай бұрын

Thank you sir

@user-gm9kv9cw8j 7 ай бұрын

Please make video for bulk insert from excel to sql server like 1m row insert at one click

@dexcodelab 4 ай бұрын

That sounds good! I'll keep it in mind for future content.

@hoangminhnguyen9571 8 ай бұрын

Can you do a video about export excel file from db?

@dexcodelab 8 ай бұрын

I don't promise but i will try

@randnas Ай бұрын

How can I import data with more than one file to more than one table??

@dexcodelab Ай бұрын

First make the html input tag to select multiple files. Second convert IFormFile to List files. Then loop through files and perform import operation on each file.

@sunnyafran415 8 ай бұрын

I can't add import excel file to datagridview then save to database at the same project, you have uploaded two different tutorials ,please give a tutorial import excel file display DataGridView and save to database in same project without migration, please it's urgent.

@dexcodelab 7 ай бұрын

Sorry, i have a busy schedule these days, once i will find time i will do it. Do you want it done with db first approach?