I'm so sorry to hear that, Colin.
That's realy tough. But don't forget to give yourself credit for asking her. Although you didn't receive the answer you wanted to hear, like Dan and Dogstar said, sometimes is worse not knowing how someone feels. I know it's hard to be alone but you're a wonderful guy and you will find the right girl.