best way to insert 1000 records in loop

What is best/recommended way to insert 1K records
1)
- open db connection
- start loop and insert records / executeNonQuery()
-close database

OR
2)
- start loop
-open db
- insert
-close db
- go to next record