Sean Connery, who rose to super-stardom after playing James Bond in the 1960s and early 1970s, has died at the age of 90, his family told the BBC.