TV tuners cards will take analog out from the STB or cable so it doesn't matter whether its DTH, cable etc. You won't get the digital stream, that's encrypted and protected by the STB. You get the analog out which has been converted by the STB digital-analog converter that goes to the TV.
You do get cards that can capture DVB-C (digital cable), or DVB-S (Digital satellite) like Skystar or Technotrend but most of the broadcasts are encrypted by major encryption systems like NDS (TataSky), Conax (Dish TV) and are also paired with the STB so its a moot point what these cards can accomplish without major hackery which would be illegal. In the US its now a legal requirement for companies to provide a digital out in their stb's via a firewire port. There should be similar requirment here so we can get the streams if we want on our PCs.
Anyway TV is so sad there is hardly anything worth watching forget recording. We should be paid to watch and record rather than broadcasters encrypting streams.