I was wondering if I could make a network connection with two computers using only our wireless cards?

Yes, it's known as an Ad Hoc network.