datareader.close() after return ??

[DotNetDev]

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 ;
}

"DotNetDev" <Do*******@discussions.microsoft.comwrote in message
news:36**********************************@microsof t.com...

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