The question you are asking is a bit confusing. You first state that you want a wired connection, but then you do not want to connect the computers together via wire because they are in separate rooms?
If I may ask a couple questions to help you out. Do any of the computers in your home connect to the internet now? I'm assuming that answer to that question is yes, because you are on this forum. More details, the better though. Who is your cable provider? Are you connecting via cable internet or dsl? Or are you using dial up internet?
Do you want to have wireless internet in your home? So you can connect multiple computers to the interment without the use of wires?