ASP.NET

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();
}

HtmlGenericControl[] objLi = {new HtmlGenericControl(),new HtmlGenericControl(),new HtmlGenericControl(), new HtmlGenericControl(), new HtmlGenericControl()}:
objLi[0].InnerHtml = "First element";
objLi[1].InnerHtml = "Second Element";

HtmlGenericControl[] objLi = new HtmlGenericControl[5];<br />
objLi[0] = new HtmlGenericControl();<br />
objLi[0].InnerHtml = "First element";<br />
objLi[1] = new HtmlGenericControl();<br />
objLi[1].InnerHtml = "Second Element";