I have been trying to make realistic water but the only thing that i seem to find is to make an ocean or lake. I want to make fluid that can pour splash.ect My first thought was to do lots of little spheres but that might slow it down, any suggestions, or how to make fluid?

Thanks, Willy

Well, you might be able to come up with something that looks okay using a carefully designed sprite particle system similar to these samples:

http://creators.xna.com/en-US/sample/particle3d

http://creators.xna.com/en-US/tutorial/particlexml

This is not an easy effect to achieve, especially in real-time, but there are lots of articles on the net that may help you:

http://www.google.com/search?q=realtime+fluid&sourceid=ie7&rls=com.microsoft:en-US&ie=utf8&oe=utf8&rlz=

Yeah.. that's going to be really difficult.  Maybe impossible.  Simulating water is difficult.  Not impossible, but because water is not a solid it involves lots of calculations.  Most games use water as oceans or lakes, the water body's position is fixed.  This allows for lots of assumptions that reduce the CPU load.  Having water that behaves as a true fluid would require something much more complex.

Your idea with the spheres is a good one, I have seen implementations go down that route, but it's much more complicated than you probably think.  Check out some of the free books here under GPU Gems to see some implementations of water: http://developer.nvidia.com/page/home.html