Gridview binding & sqlconnection in asp.net

con2 = new SqlConnection();
con2.ConnectionString = @"Your connection String";
con2.Open();


 string name = "select Field from tablename";
 SqlDataAdapter name_ad = new SqlDataAdapter(name, con2);
 DataSet name_ds = new DataSet();
 name_ad.Fill(name_ds);

 Gridview1.Datasource=name_ds;
 Gridview1.Databind();

Con2.close();