asp.net sql query help
<p>i have a sql query in asp.net</p>

<pre><code>SqlCommand QueidCmd = new SqlCommand("select scope_identity() from table1", conn);
</code></pre>

<p>i want to take the output and store it in variable
use this variable in another insert query which is just below it...both of these queries are in loop...can this be done??</p>
