public DataSet GetDataSet(string sql) { DataSet ds = new DataSet(); SqlConnection con = new SqlConnection(conn); con.Open(); try { SqlDataAdapter da = new SqlDataAdapter(sql, con); da.Fill(ds); } catch { } finally { con.Close(); } return ds; }