共用方式為


PipelineComponent.ReleaseConnections 方法

Frees the connections established during AcquireConnections. Called at design time and run time.

命名空間:  Microsoft.SqlServer.Dts.Pipeline
組件:  Microsoft.SqlServer.PipelineHost (在 Microsoft.SqlServer.PipelineHost.dll 中)

語法

'宣告
Public Overridable Sub ReleaseConnections
'用途
Dim instance As PipelineComponent

instance.ReleaseConnections()
public virtual void ReleaseConnections()
public:
virtual void ReleaseConnections()
abstract ReleaseConnections : unit -> unit  
override ReleaseConnections : unit -> unit
public function ReleaseConnections()

備註

Called repeatedly during component design, and at the end of component execution. Components should release any connections that were opened and maintained in AcquireConnections.

範例

private System.Data.OleDb.OleDbConnection oledbConnection;
public override void ReleaseConnections()
{
    if (oledbConnection != null && oledbConnection.State != ConnectionState.Closed )
        oledbConnection.Close();
}
Private oledbConnection As System.Data.OleDb.OleDbConnection 

Public Overrides Sub ReleaseConnections() 
 If Not (oledbConnection Is Nothing) AndAlso Not (oledbConnection.State = ConnectionState.Closed) Then 
   oledbConnection.Close 
 End If 
End Sub

請參閱

參考

PipelineComponent 類別

Microsoft.SqlServer.Dts.Pipeline 命名空間