jwcolby
jwcolby at colbyconsulting.com
Mon Feb 14 19:24:18 CST 2011
I have a connection, a command object and a data reader (all SQL objects). Do I need to close them in any specific order? ATM the code does this: SqlDataReader dr; SqlConnection cnn = new SqlConnection(clsGlobals.myConnection); cnn.Open(); SqlCommand cmd = new SqlCommand(SQL, cnn); dr = cmd.ExecuteReader(); while (dr.Read()) { } cnn.Dispose(); cnn.Close(); cmd.Dispose(); dr.Dispose(); dr.Close(); -- John W. Colby www.ColbyConsulting.com