Hi,

Today a connection is being openned for each module in the page. I don't want to do this.
I want to use a unique connection in each request. To do this I changed the PortalModuleControl class to receive my connection. Ok, it's working. But in the web controls the connection is being closed when passing by DataBind method.

Can anyone give me a clue?

Dim links As New PortalLagoinha.Net.LinkDB(Connection) 'Here I pass the connection

myDataList.DataSource = links.GetLinks(ModuleId)
myDataList.DataBind() 'Here the connection is being closed :-(

Thanks,

Aline.

You could try using a different CommandBehavior instead of CloseConnection. Take a look at the GetLinks function in Components/LinksDB.vb, you will find this:

Dim result As SqlDataReader = myCommand.ExecuteReader(CommandBehavior.CloseConnection)

When the command is executed, the associated Connection object is closed when the associated DataReader object is closed. I would guess that the DataReader is being closed after the databind method is called, perhaps as part of the garbage collection.

---

Jared Livingston
MrLivingston.com - Livingston Family Website

Test/Demo site - moonmark.com

Thank's a lot. I thought it was closing in DataBind.. but it the connection is closed when the associated DataReader object is closed. ;)

Aline