How to Close a Connection with the Host File Adapter

If you create a HostFileDataAdapter object with a connection string, the object will automatically create a connection object. Once you are finished using a host file adapter, you need to dispose of the implicit connection you made. You can use the Dispose and Close commands to do so.

To close the connection created implicitly through a HostFileDataAdapter object

1. Once you are finished with the connection, call HostFileDataAdapter.Dispose() to dispose of the connection.

2. Alternately, you may also call HostFileDataAdapter.SelectCommand.Connection.Close() to close the connection as well.

Example

The following code sample shows how to create a connection through a HostFileDataAdapter object, and how to properly dispose of the connection.

try  
{  
    HostFileDataAdapter hfda = new HostFileDataAdapter(SELECT,"valid connection string");  
    DataSet ds = new DataSet();  
    hfda.Fill(ds);  
    string xml = ds.GetXml();  
    Console.WriteLine(xml);  
    hfda.Dispose();  
}  
catch (Exception e)  
{  
    Console.WriteLine(e.Message);  
}  

See Also

Working with the Host File Adapter and Dataset