>I was speaking in general terms - it's obviously not a good idea to call .Dispose() on an item that will remain in scope and, on that basis, I've never consiously done so (I'd rather not give unexpected behaviour a chance :-} ).
>Can you show an example of how you are using an SqlDataAdapter in a using block ?

Some declarations:

        Public oDataSet As DataSet = Nothing
        Private oCommand As IDbCommand = Nothing
        Private oDataAdapter As IDbDataAdapter = Nothing

Based on the backend, I have this:

            ' Different backends handle it differently
            Select Case nSQLMode

                ' OleDb
                Case 1
                    oDataAdapter = New OleDbDataAdapter
                    oCommand = New OleDbCommand

                    ' SQLClient
                Case 2
                    oDataAdapter = New SqlDataAdapter
                    oCommand = New SqlCommand

                    ' ODBC
                Case 3
                    oDataAdapter = New OdbcDataAdapter
                    oCommand = New OdbcCommand

            End Select

Some initializations:

                oCommand.CommandText = tcSQL
                oDataAdapter.SelectCommand = oCommand

                oDataSet = New DataSet

This is where the query happens:

                                Using loSQLConnection As New SqlConnection(lcConnectionString)
                                    oCommand.Connection = loSQLConnection
                                    oDataAdapter.Fill(oDataSet)
                                End Using