HELP: CommandBehavior.CloseConnection

[Mark]

I have a data access component that returns a SqlDataReader object.

public SqlDataReader GetFeaturedArtists()
{
SqlConnection conn = new
SqlConnection(ConfigurationSettings.AppSettings["DBConnectionString"])
using(SqlCommand cmd = new SqlCommand(
"SELECT artistName, ar.artistId "+
"FROM featuredArtist fa "+
"JOIN artist ar ON fa.artistId=ar.artistId"
))
{
cmd.Connection = conn;
conn.Open();
return cmd.ExecuteReader(CommandBehavior.CloseConnection) ;
}
}

For obvious reasons I can't enclose the SqlConnection in a "using" statement
else the connection will be closed when this method returns.

Now, the returned SqlDataReader is bound to a DataGrid in one of my ASP
pages...

private void Page_Load(object sender, System.EventArgs e)
{
ArtistDALC artistDALC = new ArtistDALC();
DataGridFeaturedArtist.DataSource = artistDALC.GetFeaturedArtists();
DataGridFeaturedArtist.DataBind();
}

Now my question is, when the grid has read the data returned from the
SqlDataReader, the connection gets closed *but* does the Dispose method of
the SqlConnection object also get called?

Any help much appreciated...

--
Best regards
Mark Baldwin
Software Developer