Is it a good practice to use many stored procedures instead of putting code directly in the page?

It can be, but there are reasons to do both, and arguments can be made that support both. Sometimes a stored proc will be faster, or provide better security, or hide complextity from the web developer, or improve scalability.

Another choice is to write a "business" layer, or data access layer, or both to make a more logical design. These layers are often written in some code that can be compiled, like a VB COM+ dll, or C++ COM+ dll.

Overall, though, it really depends on how complex your application is. For a simple dynamic website that doesn't get much traffic, and isn't dealing with lots of data that needs to be kept secure, it won't make much difference, if any. One common approach is to do the simplest thing that works, and revisit it later if or when needed.

This is a complicated topic with many things to consider.

Have fun

Woody Z http://www.learntoprogramnow.com

thanks woodyZ.you are an expert