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.
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.
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.
Thank you very much! Finally, thanks to your video tutorial, I understood this topic!)
You're welcome. Glad it helped!
very organized and clear, Thank you🙏
Glad it was helpful!
Thanku bro this solution is best one
You're welcome
Very good explanation. Short and clear.
Glad you liked it
Amazing thanks for your labor and solution. !!! We are excitedly waiting for content.
Thankyou for liking the content, will try to upload more helpful content in future
Very good video, really understood. data can be saved very 👍👍👍👍
Thank you sir
that was perfect
Thankyou sir
Thank u man keep going!
You're welcome
nice job! thanks for doing this.
My pleasure!
Thank you very much!
You're welcome sir
Nice explanation..very useful
Thank you sir
Please make video for bulk insert from excel to sql server like 1m row insert at one click
That sounds good! I'll keep it in mind for future content.
FormatException: Input string was not in a correct format.
mainExcelFile.PoNo = Convert.ToInt32(reader.GetValue(1).ToString());
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.
thanks you for tutorial ^^
You're welcome 😊
How can I import data with more than one file to more than one table??
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.
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.
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?
Can you do a video about export excel file from db?
I don't promise but i will try
Is it with the validation too
Validation of?
@@dexcodelab SQL data types
Can you please share the exact error?
I am getting an error can you please help me with that error 🙏
Where are you getting the error?
@@dexcodelab during the database app user creation
Can you please share the exact error?
how to change it to Net core web APi
Sure, i will try to make a video for this
@@dexcodelab thank you
welcome sir, New video with API is uploaded