As far as the college sporting event goes, nothing in the state statutes prevents it from being in your car that I know of, unless the laws against carrying at school events apply but I think those apply to state run schools (most of the laws deal with high school and below). Most colleges will have their own rules and regs against carrying though. and if caught you might be charged with trespassing or some BS charge like that. You might want to check out the school you are going to on the web first to see if they ban guns- most if not all of them do though.
There is a restriction against carrying anywhere that a fee has been charged so taking it inside is probably not legal but I'm not sure that applies to parking lots at those events.
You can also check out the pamphlet at the top of the NC forums here to see other rules and regs. It's pretty OC/ CC friendly here in NC but there are some shadowy areas as well. One note will depend on what town you are going to as Cary and Chapel Hill have some funky laws within town limits.