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

Рет қаралды 10,766

Dex Code Lab

Күн бұрын

Пікірлер: 48

@olegpogorelov5223 7 ай бұрын

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

@dexcodelab 7 ай бұрын

You're welcome. Glad it helped!

@aliyousef4755 27 күн бұрын

very organized and clear, Thank you🙏

@dexcodelab 27 күн бұрын

Glad it was helpful!

@namessis 3 ай бұрын

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

@dexcodelab 3 ай бұрын

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

@pamodpeiris154 5 ай бұрын

Very good explanation. Short and clear.

@dexcodelab 5 ай бұрын

Glad you liked it

@ekremozafsar2875 9 ай бұрын

Thank u man keep going!

@dexcodelab 9 ай бұрын

You're welcome

@bipinlal1724 7 ай бұрын

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

@dexcodelab 7 ай бұрын

Thank you sir

@juliuszhu9123 4 ай бұрын

nice job! thanks for doing this.

@dexcodelab 4 ай бұрын

My pleasure!

@CyberHelp1 3 ай бұрын

Thanku bro this solution is best one

@dexcodelab 3 ай бұрын

You're welcome

@myti1617 6 ай бұрын

that was perfect

@dexcodelab 6 ай бұрын

Thankyou sir

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

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

@dexcodelab 6 ай бұрын

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

@hieuang79 5 ай бұрын

Thank you very much!

@dexcodelab 5 ай бұрын

You're welcome sir

@raziuddinmohd 11 ай бұрын

Nice explanation..very useful

@dexcodelab 11 ай бұрын

Thank you sir

@hoangheo2505 10 ай бұрын

thanks you for tutorial ^^

@dexcodelab 10 ай бұрын

You're welcome 😊

@randnas 4 ай бұрын

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

@dexcodelab 4 ай бұрын

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.

@ShanteshManure 22 күн бұрын

FormatException: Input string was not in a correct format. mainExcelFile.PoNo = Convert.ToInt32(reader.GetValue(1).ToString());

@dexcodelab 21 күн бұрын

I think the cell value is not numeric or its either null that why conversion has failed. Create a try catch block to skip the bad row or use int.TryParse method. Incase of bad row you can also put a hardcoded default value like 0 or make a list of all bad rows and at the end you can display data that is not inserted and has errors.

@bruhmanbruhmanzz 10 ай бұрын

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

@dexcodelab 10 ай бұрын

I don't promise but i will try

@tharun4939 11 ай бұрын

Is it with the validation too

@dexcodelab 11 ай бұрын

Validation of?

@tharun4939 11 ай бұрын

@@dexcodelab SQL data types

@dexcodelab 11 ай бұрын

Can you please share the exact error?

@sunnyafran415 10 ай бұрын

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 10 ай бұрын

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?