ASP.NET

Page page = HttpContext.Current.Handler as Page;

  public void AddJavascript(string javascriptUrl)<br />
        {   //This method adds the JavaScript File to the page<br />
            HtmlGenericControl script = new HtmlGenericControl("script");<br />
            script.Attributes.Add("type", "text/javascript");<br />
            script.Attributes.Add("src", ResolveUrl(javascriptUrl));<br />
            this.Page.Header.Controls.Add(script);<br />
        }<br />
<br />
 protected void Page_Load(object sender, EventArgs e)<br />
        {<br />
AddJavascript("~/Scripts/ImageRight.js");<br />
}

using (conn = new SqlConnection())
{
   //Do some data access stuff here
}

V. wrote:

We've spent the entire day looking at why our code kept open several Oracle socket connections on the web server. After a while, we saw that the .Close function was almost never called. Yeah, we thought, this is it. So I made a quick and dirty ASP.Net page with the proper dll's, a button that opens the connection and one that closes it... The socket stays open...

ToddHileHoffer wrote:

If you do not close the connection during that same postback, it is going to remain open.

ToddHileHoffer wrote:

So if your application is leaving the connection open after a postback, you have to go back and fix the code. All 20,000 lines of it.

V. wrote:

Please explain... I find this hard to believe

If I do:
CON.Open(...); in one function. Do some stuff with it and after eg. leaving the page and doing CON.Close();
it doesn't close?

This seems very hard to believe, ESPECIALLY if I would put my CON object in a Session object??

Now you got me confused...

<br />
plubic class TryToPutMeInSession<br />
{<br />
<br />
public TryToPutMeInSession ()<br />
{<br />
}<br />
<br />
}<br />
<br />
//Try adding the class to session. It will throw an exception tellin you that you need the class nees to be Serializable.<br />

<br />
[Serializable]<br />
plubic class TryToPutMeInSession<br />
{<br />
<br />
public TryToPutMeInSession ()<br />
{<br />
}<br />
<br />
}<br />

Paddy Boyd wrote:

do you have access to common methods to create and close connections?

Paddy Boyd wrote:

and is really not good practice

SqlConnection conn;

public SqlConnection GetConnection()
{
   conn = new SqlConnection(connString);
   conn.open();

   return conn;
}
public void CloseConnection()
{
     conn.close();
}