>Documentation states that if the connection is not open when Fill() is called (which should be the case here) then the connection is automatically opened and *automatically closed* when the Fill() completes.

This is what I assumed for years. But, if that line executes, and if I stop the code right after that, click on the button to restore, it says the database cannot be opened exclusively.

>Where does this ensure that the DataAdapter is actually using loSQLConnection ?

>Using loSQLConnection As New SqlConnection(oApp.aConnection(nConnectionString, 1))
>   oCommand.Connection = loSQLConnection
>   oDataAdapter.Fill(oDataSet)
>End Using

It goes like this:

Public oDataSet As DataSet = Nothing
Private oSqlCommand As SqlCommand = Nothing
Private oSqlDataAdapter As SqlDataAdapter = Nothing

oSqlCommand.CommandText = lcSQL
oSqlDataAdapter.SelectCommand = oSqlCommand
oDataSet = New DataSet

Using loSQLConnection As New SqlConnection(oApp.aConnection(nConnectionString, 1))
   oSqlCommand.Connection = loSQLConnection
   oSqlDataAdapter.Fill(oDataSet)
End Using