If the code you have posted is accurate you open your
SqlConnection
(con) and then immediately close it again without doing anything with it.
You might consider doing something like
con.Open();
adapter1.Fill(dset1);
con.Close();
or reading the data in some other way.