Insert multiple DB rows from listview - VB.NET MYSQL

Question

I have a listview that can contain up to roughly 2,000 listview items I need to loop through the listview and insert each item into a mysql database

is there a better, bulk way, to insert the data instead of doing an insert for each item like follows:

for each itm ...
  insert into whatever ( id ) values ( itm.text ) ...
next

Thanks

ipr101 · Accepted Answer · 2011-08-08 15:29:45Z

1

You could build up a file containing the changes and then use the 'LOAD DATA INFILE' functionality -

answered Aug 8, 2011 at 15:29

ipr101

24.2k8 gold badges61 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1