The "Limited or No Connectivity" indication means that the network adapter has been unable to get an IP address from the router and has been allocated a default one in the 169.254.x.x range by Windows. This will not let you get online.
Have you actually "Connected" to the wireless network? In other words, have you run the wireless adapter's software, scanned for "Available Wireless Networks", found and highlighted the one that matches your router's SSID (network name) and selected the option to "Connect" to it? Once "Connected", the wireless adapter should get its IP address by DHCP from the router and you should have network and internet access.
There is a difference between the Wireless Network Adapter and Router communicating with a good signal and "Connecting" (as in "logging in") to your Wireless network.