Como: Descartar um recurso do sistema (Visual Basic)

Artigo
08/08/2011

You can use a Using block to guarantee that the system disposes of a resource when your code exits the block. This is useful if you are using a system resource that consumes a large amount of memory, or that other components also want to use.

To dispose of a database connection when your code is finished with it

Make sure you include the appropriate Declaração Imports (Tipo e Namespace .NET) for the database connection at the beginning of your source file (in this case, System.Data.SqlClient).
Create a Using block with the Using and End Using statements. Inside the block, put the code that deals with the database connection.
Declare the connection and create an instance of it as part of the Using statement.
```
' Insert the following line at the beginning of your source file.
Imports System.Data.SqlClient
Public Sub AccessSql(ByVal s As String)
    Using sqc As New System.Data.SqlClient.SqlConnection(s)
        MsgBox("Connected with string """ & sqc.ConnectionString & """")
    End Using
End Sub
```
The system disposes of the resource no matter how you exit the block, including the case of an unhandled exception.

Note that you cannot access sqc from outside the Using block, because its scope is limited to the block.

You can use this same technique on a system resource such as a file handle or a COM wrapper. You use a Using block when you want to be sure to leave the resource available for other components after you have exited the Using block.

Consulte também

Partilhar via

Como: Descartar um recurso do sistema (Visual Basic)

To dispose of a database connection when your code is finished with it

Consulte também

Tarefas

Referência

Conceitos

Outros recursos

Recursos adicionais