I've also had this trouble for two days... Strange part is that the ethernet connection at my office works fine, but not at home. I thought it was a defective cable or switch. The other computers on my home network worked fine and I tried the afore mentioned cable swap, port swap out the router and switch, Reset PRAM, went to church on Sunday, made my bed, etc... Nothing worked.
I ended up restarting with the Ethernet cable plugged in > In system preferences I setup a manual connection instead of DHCP. It didn't take at first, but when I ran the "assist me" option, I selected the Built-In Ethernet, went through the process, and it seemed to work. So far, so good...
One interesting note, I have Parallels installed and the Parallels program was able to see the Internet even though the Mac side was not (said the cable was unplugged on the mac side). I have about 15 MacPro's running on my office network and a couple more at home. This has only happened on my MBP 17" (2.16)... Running SonicWall TZ170 on both networks. Weird stuff. This solution got me up and running again. Hope this helps.