Re: Garbage Collection in .NET?

[Reggie Burnett]

Timothy

You have a couple of problems in the code you posted.

#1: if an exception is thrown during the while(reader.Read()) loop, you will not close the reader
#2: and this is not really a problem but you should use a finally block to close things up. Here is an alternate writing

MySqlDataReader reader = null;
try {
reader = cmd.ExecuteReader();
while (reader.Read() ) { ... }
retrn myReturnValue;
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
throw;
}
finally {
if (reader != null) reader.Close();
conn.Close();
}