Have you been to Canada? This is most common.
Did you (ever) go to Canada? This is possible in a context where the questioner knew the person would likely go there.
Had you been to Canada? This is not correct.
If I say this sentence [STRIKE]in[/STRIKE] about the past..