How to find the last time execution of the loop while(dr.Read())?
<p>take a look at the below while loop.</p>

<pre><code>SqlDataReader dr;

while (dr.Read())
{

Response.Write("insert into test values(N'"+dr[0]+"', N'"+dr[1]+"'),&lt;br&gt;");

}
</code></pre>

<p>I am just printing something with a comma at the end (before that <br>). But For the last time when it gets printed, i dont want that comma. 
How to find out that this loop is executing for the last time? so that i can avoid this comma getting printed by modifying it.</p>
