Yes, the 945G Chipset
supports dual core Pentium D and some Core 2 Duo CPUs.
motherboard supports these CPUs is another story.
Check your manufacturers product page and see the CPU Support List for your motherboard.
If the CPU you want to upgrade to is supported, make sure your BIOS is updated before installing it.