I am uploading a excel file with 10 rows using file upload widget and after uploading I am giving the all data to insert into external database. But when I upload only the first row of the excel gets inserted. How can I insert all the rows of the uploaded excel directly after uploading?
Re: Insert all the uploaded rows in external database
This code seems to create an infotable out of a CSV file, I don't see the actual insertion here.
You can either iterate and insert row by row, or transform the infotable to insert all at once.
I honestly don't know exactly what format you need to insert multiple lines at once into a Database but if it is just a repeat of the value rows, you can iterate and create that string and add that to your sql.
you may have to use string substitution vs. parameter substitution.