Give an example to ensure the database connections are always closed ?

To find whether the database connections are always closed, you have to open the connection inside of a using block.
By doing this, you will come to know that the connection is automatically closed when the code exits the block.

using (SqlConnection ConnectionObject = new SqlConnection())
{
ConnectionObject.Open();
//The database connection will be closed when the control exits the using code block
}