Dispose Method
Collapse the table of content
Expand the table of content

SqlDataAdapter.Dispose Method

.NET Framework 1.1

Releases the resources used by the SqlDataAdapter.

Overload List

Releases the unmanaged resources used by the SqlDataAdapter and optionally releases the managed resources.

Supported by the .NET Compact Framework.

[Visual Basic] Overloads Overrides Protected Sub Dispose(Boolean)
[C#] protected override void Dispose(bool);
[C++] protected: void Dispose(bool);
[JScript] protected override function Dispose(Boolean);

Inherited from Component.

Supported by the .NET Compact Framework.

[Visual Basic] Overloads Public Overridable Sub Dispose() Implements IDisposable.Dispose
[C#] public virtual void Dispose();
[C++] public: virtual void Dispose();
[JScript] public function Dispose();


[Visual Basic, C#, C++] The following example creates a SqlDataAdapter and then disposes of it.

[Visual Basic, C#, C++] Note   This example shows how to use one of the overloaded versions of Dispose. For other examples that might be available, see the individual overload topics.
[Visual Basic] 
Public Sub SqlDataAdapterHereAndGone()
    Dim myDataAdapter As New SqlDataAdapter()
End Sub 'SqlDataAdapterHereAndGone

public void SqlDataAdapterHereAndGone() {
           SqlDataAdapter myDataAdapter = new SqlDataAdapter();

void SqlDataAdapterHereAndGone() {
           SqlDataAdapter* myDataAdapter = new SqlDataAdapter();

[JScript] No example is available for JScript. To view a Visual Basic, C#, or C++ example, click the Language Filter button Language Filter in the upper-left corner of the page.

See Also

SqlDataAdapter Class | SqlDataAdapter Members | System.Data.SqlClient Namespace

© 2016 Microsoft