Keith,

Thanks for the response

Would I be better off caching the parameters in advance, in the Application_Start method in the Global.ASAX file?

Thanks again

Rex

>The advantage is that you don't have to hand-code a bunch of SqlCommand.Parameters.Add() statements. The other available method of setting up the SqlCommand parameters is to use the SqlCommandBuilder, which has a larger footprint than the Blocks and retreives the parameter metadata from SQL Server each time it is used.
>
>P.S. The parameters collection is instanced each time a SqlCommand object is created, but not when the stored procedure is used.
>
>>All,
>>
>>In the Microsoft Data Access Application Block I noticed that parameter caching was used. What are the advantages of data caching instead of instantiating the parameter objects each time a stored procedure is used?
>>
>>Thanks
>>
>>Rex