protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e)
{
SqlConnection MyConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["conn1"].ConnectionString);
try
{
MyConn.Open();
string strSql = "select top 10 * from Store";
SqlCommand cmd = new SqlCommand(strSql, MyConn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{ DataRowView myRow = (DataRowView)e.Item.DataItem;
HyperLink HyperLink1 = (HyperLink)e.Item.FindControl("HyperLink1");
if (myRow["Description"].ToString().Trim().ToLower() == "null" || myRow["Description"].ToString().Trim() == "")
{
HyperLink1.Text = "暂无数据";
}
else
{
HyperLink1.Text = myRow["Description"].ToString().Trim();
}
HyperLink1.NavigateUrl = "A"+myRow["Id"].ToString().Trim();
this.DataList1.DataBind();
}
}
}
finally
{
MyConn.Close();
}
}
这段代码运行后出现:
超时时间已到。超时时间已到,但是尚未从池中获取连接。出现这种情况可能是因为所有池连接均在使用,并且达到了最大池大小。为什么会这样?应该如何修改?谢谢了!
{
SqlConnection MyConn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["conn1"].ConnectionString);
try
{
MyConn.Open();
string strSql = "select top 10 * from Store";
SqlCommand cmd = new SqlCommand(strSql, MyConn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{ DataRowView myRow = (DataRowView)e.Item.DataItem;
HyperLink HyperLink1 = (HyperLink)e.Item.FindControl("HyperLink1");
if (myRow["Description"].ToString().Trim().ToLower() == "null" || myRow["Description"].ToString().Trim() == "")
{
HyperLink1.Text = "暂无数据";
}
else
{
HyperLink1.Text = myRow["Description"].ToString().Trim();
}
HyperLink1.NavigateUrl = "A"+myRow["Id"].ToString().Trim();
this.DataList1.DataBind();
}
}
}
finally
{
MyConn.Close();
}
}
这段代码运行后出现:
超时时间已到。超时时间已到,但是尚未从池中获取连接。出现这种情况可能是因为所有池连接均在使用,并且达到了最大池大小。为什么会这样?应该如何修改?谢谢了!
晕啊,这个我已经在webconfig中写好了,不是这个原因!
这什么东西