SqlDataReader Close problem.

[swtrse]

I use the SqlHelper class to call an stored procedure.

....
conn = getSqlConnection();
reader = SqlHelper.ExecuteReader(conn, CommandType.StoredProcedure,
"aus_getZuBerechnendeAusAuftraegeForDatum", sqlParams);
while(reader.Read())
{
....
}
reader.Close();
releaseSqlConnection(conn);
....

So all work fine but the reader.Close() command never comes back to my
funktion.

My question why?
Has anyone an Idea?

 

[Joe Fallon]

dr = cmd.ExecuteReader(CommandBehavior.CloseConnection)