Also when you open the datareader, set the param toCommandBehavior.CloseConnection eg:(VB code):myDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)This will close the connection when you close the datareader.