I currently use a cable connection for my office's Internet connection and before this it was DSL. Both work fine! On to your problem.
If you still have the D-link router and haven't returned it yet, how many ports do you have on it. Depending on the model that you have it would be anywhere from 1 up. There should be an incoming port (from the cable company's modem) and an uplink port (to your computer or hub). How many computers do you want to share the Internet connection? If you want more computers than you have ports on the router, buy a cheap hub or switch from your local computer store.
The main thing, for either the D-link or the suggested Linksys routers are the configurations. You have to set the router to accept a DHCP connection from the Cable company and also give out DHCP to your clients. You could also give your computers a static IP if you wanted. Either way, this has to be done! Use a private address for inside YOUR network computers, ie. 192.168.1.x. The router will also have to have an internal IP address assigned to it too which will become your "default gateway."
The router should be able to accept a local IP address on the uplink port.
On your client computers, set the IP address for either static, (you assign) or dynamic (the router assigns). You will need to set the DNS on each computer to the Cable provider, unless you can assign that through the DHCP on the router. As well as the default gateway that I mentioned above.
Most of these steps should be contained in the documentation that came with your router. If I have totally confused you, just email me and I'll try to help. Roger