I WANT SEND ITEMS INTO DATABASE WITH ONE TIME CONNECTION OPEN ?  
         MYCONN.OPEN();
        FOR(INT I =0; I < CODE.COUNT ; I ++)
        {
        DB.SUBMITITEMS(CODE[I]); //IS IT RIGHT IF I HAVE 100 ITEMS TO SEND DATABASE WITH ONCE TIME OPEN CONNECTION OF DATABASE; OR I NEED TO REOPEN AND CLOSE CONN AFTER EVERY ONE ITEM?
        }
        MYCONN.CLOSE();

Recommended Answers

Yes you can save data as much as you have space, after opening the connection. There is no need to re open the connection again and again. After sending the data closing the connection is best practice.

Jump to Post

All 2 Replies

Yes you can save data as much as you have space, after opening the connection. There is no need to re open the connection again and again. After sending the data closing the connection is best practice.

yes you can do it just open connection complete your work and close it.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.