.net 1.1, open connections in nested repeaters

[mavrick_101]

Hi,

I have nested repeaters. But the page breaks if I refresh 2 or 3 times. It
breaks with the following error message..
"Timeout expired. The timeout period elapsed prior to obtaining a connection
from the pool. This may have occurred because all pooled connections were in
use and max pool size was reached. "

I am using the following lines for loading data in the child repeaters on
Item_DataBound of Parent Repeater.

using (SqlConnection oConn = new SqlConnection(C onnectionString s.Portal))
{
SqlCommand oCmd = new SqlCommand(strS ql, oConn);
oConn.Open();
SqlDataReader cmDataReader = oCmd.ExecuteRea der();
Repeater tempRepeater = (Repeater) rItem.FindContr ol("_childRepea ter");
if (tempRepeater != null)
{
tempRepeater.Da taSource = cmDataReader;
tempRepeater.Da taBind();
}
cmDataReader.Cl ose();
oCmd.Dispose();
}

What am I doing wrong?

[mavrick_101]

Please ignore this post.

Thnx

"mavrick_10 1" wrote:

Hi,

I have nested repeaters. But the page breaks if I refresh 2 or 3 times. It
breaks with the following error message..
"Timeout expired. The timeout period elapsed prior to obtaining a connection
from the pool. This may have occurred because all pooled connections were in
use and max pool size was reached. "

I am using the following lines for loading data in the child repeaters on
Item_DataBound of Parent Repeater.

using (SqlConnection oConn = new SqlConnection(C onnectionString s.Portal))
{
SqlCommand oCmd = new SqlCommand(strS ql, oConn);
oConn.Open();
SqlDataReader cmDataReader = oCmd.ExecuteRea der();
Repeater tempRepeater = (Repeater) rItem.FindContr ol("_childRepea ter");
if (tempRepeater != null)
{
tempRepeater.Da taSource = cmDataReader;
tempRepeater.Da taBind();
}
cmDataReader.Cl ose();
oCmd.Dispose();
}

What am I doing wrong?