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();

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 meeting, networking, learning, and sharing knowledge.