How do I connect my iPad to a Sony TV?

I’m trying to connect my iPad to my Sony TV so I can stream videos and photos, but I’m not sure which method works best. I’ve tried using AirPlay and some cables, but nothing seems to work. Would really appreciate any tips or a step-by-step guide to get this working.