Just close the reader, or whatever you are using with your command.  If you need the data later, then store the data in an array
list or something and close the reader before calling the next stored procedure.  You can call as many stored procedures as you
wish, but if you use, for example a data reader, you must close it before you call another command.
Hope this helps.  

From: "John Tyson" 
Reply-To: "ASPX_Professional" 
To: "ASPX_Professional" 
Subject: [aspx_professional] reusing connection/command objects 
Date: Wed, 28 Aug 2002 09:11:29 -0700 

Hi, 

Does anyone have an example they would be willing to post of an aspx 
page showing how to reuse the same connection and command strings with 
multiple stored procedures and parameters? I have an application that 
works well, but I use a number of different connection and command 
objects because I don't know too well how to efficiently reuse the same 
ones with changing stored procedures. 

Much Thanks. 

--- 

ASP.NET 1.0 Namespace Reference with C# 
http://www.wrox.com/acon11.asp?ISBN=1861007442 

ASP.NET 1.0 Namespace Reference with VB.NET 
http://www.wrox.com/acon11.asp?ISBN=1861007450 

These books are a complete reference to the ASP.NET namespaces 
for developers who are already familiar with using ASP.NET. 
There is no trivial introductory material or useless .NET 
hype and the presentation of the namespaces, in an easy-to use 
alphabetical order ensures a user-friendly reference format. 
We provide in-depth coverage of all the major ASP.NET classes, 
giving you those real-world tips that the documentation doesn't 
offer, and demonstrating complex techniques with simple 
examples. 

--- 
--- 
Send and receive Hotmail on your mobile device: Click Here