datareader.close() after return ??

[Guest]

Hi,

I have a function....

private bool myfunction()
{
SqlDataReader myReader = CommandObject.ExecuteReader();
if (myReader.HasRows)
return true;
else
return false;
myReader.close();
}

I want to know would the datareader be closed even after the 'return'
statement?

Thnx

 

[sloan]

Your answer is no.

return means return.
try this


private bool myfunction()
{

bool returnValue = false;
try
{
SqlDataReader myReader = CommandObject.ExecuteReader();
if (myReader.HasRows)
returnValue =true;

}
finally
{
if(null!=myReader)
{
myReader.close();
}
}

return returnValue ;
}