title: Close DataSet's underlying connection explicitly?
body: <p>I am using DataSet to retrieve data from the Microsoft SQL Server. Do I need to explicitly close the connection (or the underlying SqlDataAdapter automatically closes the connection)?</p>
  
  <p>I always use DataReader (with <em>using</em>), but first time using DataSet -- that's why wondering about best practice. Thanks in advance.</p>