Comments by udoyen (Top 2 by date)

Hi Altaf please kindly provide more details..."show the lower side of the try block. A solution I found states that you should use a while loop with the datareader.
<pre>bool hasRow = DR.Read();
if(hasRow)
{
//TODO
}</pre>

Also check out this article at MSDN (https://msdn.microsoft.com/en-us/library/ms172375.aspx). This I think would make the whole concept a bit clearer.