R.C.
I have a Sony Handicam, I really like it. It records to a DVD and there is a spot for a SD card so you can take pictures too. There is night vision option on it, which works really well. I have videoed my daughter sleeping a few times :)
There is a cord so that you can hook it up to the TV and computer. I have had mine for a little over 2 years and recorded hundreds of videos. I know it wasn't super expensive, but I'm not sure what I did pay for it.
Good luck! If you have any specific questions let me know