I have a hp pavilion slimline s3700f desktop computer with these graphics
Newegg.com - HP Pavilion Slimline S3700F(FQ568AA) Athlon 64 X2 5000+ 3GB DDR2 320GB NVIDIA GeForce 6150 SE Windows Vista Home Premium - Desktop PCs (http://www.newegg.com/Product/Product.aspx?Item=N82E16883107868)
GPU/VPU Type- NVIDIA GeForce 6150 SE
Graphics Interface- Integrated video
I am trying to play games like 007, CoD4, Assassins Creed, Etc and it doesn't meet requirements.
Could someone please give me types of graphic cards that are compatible with it and will surely work on my computer. I want a higher graphics card that would last for a while

You can use a PCIE card suggest a nvidia geforce 9 series.