Hi guys,
I was wondering whether there was a more efficient way to do numerous inserts into an oracle database.
At the moment i am doing:

Open Oracle Connection
for each row in a dgv
create insert command using cells from a row
execute command
go to next row
close oracle connection when inserted all rows

Now sometimes i only around 100 rows to insert, but at other time i have over 20,000, which is done quite slowly.
So i was wondering whether there were any more efficient ways to perform a large number of insert statements?

Any help appreciated