>Thank you for the suggestion. I will read on how to use Using/End using (new syntax to me).

You simply need to take the sample I provided and adjust as necessary. The first line will be adjusted for your connection string. oCommand and oDataAdapter are simply properties names as per their class. So, their declaration is as follow:

        Private oCommand As IDbCommand = Nothing
        Private oDataAdapter As IDbDataAdapter = Nothing