How can we force the connection object to close?

There are 2 ways you can do this:
1. using the ExecuteReader method with "CommandBehavior.CloseConnection" parameter
2. Putting the Connection object with Using statement

www.codecollege.NET|www.interviewsguru.com|The Encylopedia of Web Sites|Blogging and Earning