66 messaggi dal 01 maggio 2001
Salve :)
Sia dato il caso che sia aperta una connessione ad un database, e che successivamente venga effettuato in mancanza di un 'requisito' un reindirizzamento, prima di compiere il Response.Redirect è necessario chiudere la connessione ?

Esempio :


Conn.Open()
' lettura record
If myDataReader("nome") <> "Giacomo"  Then
Response.Redirect("altro.aspx")
Else
' fai altro
End If
Conn.Close()



è necessario prima del redirect ad altro.aspx un ulteriore Conn.Close() ?

Grazie in anticipo per qualsiasi risposta

ciao
. Atari

// Forza Reggina :)
1 messaggio dal 30 ottobre 2003
Santa Barbara, California - (October 28, 2003) - Eiffel Software today announced that future production releases of EiffelStudio and Eiffel ENViSioN! will support Microsoft Visual Studio "Whidbey"

"By following Microsoft's roadmap at Eiffel Software, we re-affirm our commitment to ensure the success of our customers," said Larry Miller, Marketing Director for Eiffel Software. "Software is a crucial element when cutting company cost. EiffelStudio and Eiffel ENViSioN! are ideal tools to realize those savings. Making them available within Microsoft Visual Studio "Whidbey" will bring developers unprecedented productivity.

EiffelStudio is a development framework that seamlessly covers the software lifecycle. It is designed for building fast, robust, scalable applications and reusable components. EiffelStudio is fully compliant and takes full advantage of the Microsoft .NET Framework's multi-language capability. It is a system which enables the production of robust, reusable objects and libraries that interoperate with all other languages and tools for the .NET Framework. EiffelStudio's Design by Contract? feature makes it easy to output bug-free code that developers can safely and reliably use to develop business-critical applications. EiffelStudio's users continuously demonstrate that they can produce 2 to 10 times as much software in the same amount of time as can be achieved with other languages and toolsets.

Eiffel ENViSioN! is an Eiffel-language plug-in for Microsoft Visual Studio .NET, a product that offers Eiffel users access to the full power of the .NET Framework.

Current Eiffel ENViSioN! features include:

* Full compatibility and integration with the Microsoft Visual Studio .NET 2002 and 2003 development environments.
* Support for Windows Forms designer
* Project references management: Project references are handled in an intuitive and simple way. References can be added and removed directly from the Visual Studio .NET Solution Explorer.
* Source code control Management: Fully implements Visual Studio .NET
* Source control management's APIs making it easier to store and retrieve sources from a source code control management system such as Microsoft Visual SourceSafe.
* .NET Framework integration: Allows calling overloaded .NET Framework methods without using mangled names.
* .NET Framework resources support: Supports inclusion of .NET Framework resources within Eiffel assemblies.
* Automation Support: Fully implements DTE so that Eiffel projects can now be managed via Automation.

According to Dr. Bertrand Meyer, Founder and Chief Architect of Eiffel Software, "EiffelStudio and Eiffel ENViSioN! are showcase examples of how the .NET Framework allows full interoperability between different programming languages. Eiffel developers using Eiffel Software's tools can capitalize on both the power of Eiffel and of the .NET Framework. We are looking forward to offering future releases of EiffelStudio and Eiffel ENViSioN! for Visual Studio "Whidbey"".

David Lazar, director of the Developer and Platform Evangelism Division at Microsoft Corp., said, "The availability of EiffelStudio and Eiffel ENViSioN! for Visual Studio 'Whidbey' will be another milestone in the .NET Framework's support for a multilanguage paradigm. Eiffel was one of the very first languages to enjoy a full implementation for the .NET Framework. We are happy that Eiffel developers will benefit from the enhancements of Visual Studio 'Whidbey' through EiffelStudio and Eiffel ENViSioN!".

Availability:

EiffelStudio and Eiffel ENViSioN! are available via the company's website, www.eiffel.com. A Free Edition of these products are available at www.eiffel.com/downloads/. Onsite training and consulting are also available from the company by inquiring at sales@eiffel.com. Eiffel Software is the world leader in Eiffel pure object-oriented programming tools. Founded in 1985, Eiffel Software produces proven professional tools and component libraries for business-critical and enterprise software developments. Eiffel Software's products enable their customers to output more and higher-quality software in less time than with any other development tools available. Its users span the globe in industries ranging from large financial institutions, to technology manufacturing, government and defense contractors, health care providers and more.


Contact: Larry Miller, Director of Marketing, +1-805-685-1006 x105, larrym@eiffel.com

Product or service names mentioned herein are the trademarks of their respective owners.



15 messaggi dal 25 maggio 2002
La soluzione più semplice, ma non l'unica è mettere un Conn.Close() all'interno dell'If prima del Response.Redirect. Altrimenti la connessione ti rimane aperta. A meno che non hai bisogno della connessione aperta anche nel °Altro.aspx°
1.818 messaggi dal 21 giugno 2001
Contributi
travieso ha scritto:
A meno che non hai bisogno della connessione aperta anche nel °Altro.aspx°

Non funziona così: la connessione rimane aperta consumando risorse ma non è più accessibile.

hyppos
<code> in giro torte sol ciclos et rotor igni</code>
38 messaggi dal 18 luglio 2003
il response.redirect mi sembra che preveda un parametro per interrompere il rendering della pagina; forse puoi provare a fare il debug e vedere se il codice va sulla close o meno; se non ci va devi chiudere; alternativamente puoi impostare il parametro di chiusura della connessione sul datareader e prima di fare il redirect chiudi il datareader.
66 messaggi dal 01 maggio 2001
ok grazie !)

// Forza Reggina :)

Torna al forum | Feed RSS

ASPItalia.com non è responsabile per il contenuto dei messaggi presenti su questo servizio, non avendo nessun controllo sui messaggi postati nei propri forum, che rappresentano l'espressione del pensiero degli autori.