Using one sqlconnection/sqlcommand through 2 DB-bound methods
<p>I have a class with a method which gets data from a database through a SELECT stored proc. This method uses a <code>SqlDbReader</code> by returning <code>ExecuteReader()</code> on a <code>SqlCommand</code>.</p>

<p>The connection and everything is made in this method, with fields (such as connection string) set as class level fields.</p>

<p>I now need to populate an array based on the results of this query (so the columns of each row will go into the array with its own index).</p>

<p>However, this query will not select all of the data from one table which is involved. I can write the queries to get what I need, but how can I use one connection throughout the class? If I instantiate the connection object and call <code>Open()</code> in the constructor, I get an exception at runtime.</p>

<p>I'm hoping for something like this:</p>

<pre><code>// At class level:
sqlconn.Open();
// sqlcommand set up


Method()
{
// Fire stored proc
// Insert results in a collection
}

Method2()
{
// Pass same collection in (use same one),
// Add new row columns into same collection
}
</code></pre>

<p>How can I do this with strict performance in mind?</p>
