Yes, the code provided disposes of resources correctly by utilizing the using statement for SqlConnection, SqlCommand, and SqlDataAdapter objects. The using statement ensures that these objects are disposed of properly even if an exception occurs.
The DataSet is returned without needing explicit disposal as it will be garbage collected once it goes out of scope.