VS2005+SQL2005 网站发布后, 总是死机问题!!!在线等

[soufre]

两个人操服务器死掉了,服务器瞬间挂掉．急

[asp_plus]

没有关闭数据库连接？？？

[soufre]

用的是DBHelper类,全是USING{}块的.我再检查下,还有没有其它原因?

[asp_plus]

DBHelper 是啥？ M$的SqlHelper那一类的？

[aweicd0395]

up pup up

[soufre]

就是这个咯
namespace CHZS.IntraWeb.DBUtility
{
/// <summary>
/// 数据访问抽象基础类
/// Copyright (C) 2007-2008 awei
/// All rights reserved
/// </summary>
public class DbHelperSQL
{
//数据库连接字符串(web.config来配置)
private string connectionString;

public DbHelperSQL(string connstr)
{
connectionString = connstr;
}

#region 公用方法

public int GetMaxID(string FieldName, string TableName)
{
string strsql = "select max(" + FieldName + ")+1 from " + TableName;
object obj = (new DbHelperSQL(connectionString)).GetSingle(strsql);
if (obj == null)
{
return 1;
}
else
{
return int.Parse(obj.ToString());
}
}

public bool Exists(string strSql)
{
object obj = (new DbHelperSQL(connectionString)).GetSingle(strSql);
int cmdresult;
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = 0;
}
else
{
cmdresult = int.Parse(obj.ToString());
}
if (cmdresult == 0)
{
return false;
}
else
{
return true;
}
}

public bool Exists(string strSql, params SqlParameter[] cmdParms)
{
object obj = (new DbHelperSQL(connectionString)).GetSingle(strSql, cmdParms);
int cmdresult;
if ((Object.Equals(obj, null)) || (Object.Equals(obj, System.DBNull.Value)))
{
cmdresult = 0;
}
else
{
cmdresult = int.Parse(obj.ToString());
}
if (cmdresult == 0)
{
return false;
}
else
{
return true;
}
}
#endregion

#region 执行简单SQL语句

/// <summary>
/// 执行SQL语句，返回影响的记录数
/// </summary>
/// <param name="SQLString">SQL语句</param>
/// <returns>影响的记录数</returns>
public int ExecuteSql(string SQLString)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand(SQLString, connection))
{
try
{
connection.Open();
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (System.Data.SqlClient.SqlException E)
{
connection.Close();
throw new Exception(E.Message);
}
}
}
}


/// <summary>
/// 执行SQL语句，设置命令的执行等待时间
/// </summary>
/// <param name="SQLString"></param>
/// <param name="Times"></param>
/// <returns></returns>
public int ExecuteSqlByTime(string SQLString, int Times)
{
using (SqlConnection connection = new SqlConnection(connectionString))
{
using (SqlCommand cmd = new SqlCommand(SQLString, connection))
{
try
{
connection.Open();
cmd.CommandTimeout = Times;
int rows = cmd.ExecuteNonQuery();
return rows;
}
catch (System.Data.SqlClient.SqlException E)
{
connection.Close();
throw new Exception(E.Message);
}
}
}
}



太长了.....

[怪侠]

我也遇到这样的问题，开始一位是硬件问题，折腾N久
后面发现是数据库导致，我使用的是存储过程，刚开一晚上就挂掉了
看来被迫只能使用SQL2000了