>Why not? Open, Execute, Close. Do it however many times are required. I don't think you will find the overhead to be as high as you fear.
Well, if I need to do 20 SQL commands, it is must better to only have one open and one close. I do not see what I should open and close the connection for each SQL command from the same hit.