An Easy Way To Query a Database

public DataSet select_query(string query, string con_str)
{
  using (SqlDataAdapter da = new SqlDataAdapter(query, con_str))
  {
    DataSet ds = new DataSet();
    da.Fill(ds);  // Automatically opens/closes connection.
    return ds;
  }
}

public int modify_query(string query, global_data data)
{
  using (SqlConnection con = new SqlConnection(data.Con_Str))
  {
    using (SqlCommand comd = new SqlCommand(query, con))
    {
      con.Open();
      int x = comd.ExecuteNonQuery();
      con.Close();
      return x;
    }
  }
}