How do I make the quality on DVDs better?

I have a Sony Camcorder and have recorded footage, I have downloaded footage onto computer which when played back on computer screen is fine, however when transferred to DVD the quality is terrible. Can anyone recommend a good movie making software or answer what I am doing wrong? I am using a NeroSmart software package to capture the footage and copy to DVD.