一開始以為是數據庫死鎖造成的后來設置了數據庫鎖超時時間為2000毫秒但是還是會出現頁面一直卡在那里，不知道為什么？sqlserver設置鎖超時時間setlock_timeout2000select@@lock_timeout難道代碼邏輯有問題？C#代碼如下：[down.aspx]stringidString=Request.QueryString["id"]??string.Empty;intid=0;if(!int.TryParse(idString,outid)){return;}vardbeh=Common.DB.Factory.CreateDBEntityHelper();if(int.TryParse(idString,outid)){vardlh=newDownLinkHelper();stringdownlink=dlh.GetDownlink(id);if(!string.IsNullOrEmpty(downlink)){Response.Redirect(Server.UrlPathEncode(Server.UrlDecode(downlink)));}}[DownLinkHelper.cs]usingSystem;usingSystem.Collections;usingSystem.Collections.Generic;usingSystem.Linq;usingSystem.Text;usingSystem.Web;usingSystem.Web.Caching;//////DownLink的摘要說明///publicclassDownLinkHelper{Common.DB.IDBEntityHelperdbh=Common.DB.Factory.CreateDBEntityHelper();publicstringGetDownlink(intval){varent=dbh.GetEntity("SoftID="+val);if(ent!=null){returnent.Address;}returnstring.Empty;}}usingSystem;usingSystem.Collections;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Data.Common;usingSystem.Data.SqlClient;//////SQLServerHandler的摘要說明///publicclassDBHelper:IDBHelper{stringconnectionString;publicstringConnectionString{get{returnconnectionString;}set{connectionString=value;}}publicDBHelper(stringconnectionString){this.connectionString=connectionString;}publicDbCommandCreateCommand(){returnnewSqlCommand();}publicDbConnectionCreateConnection(){returnnewSqlConnection(connectionString);}publicDbParameterCreateParameter(stringname,objectvalue){DbParameterparameter=CreateParameter();parameter.ParameterName=name;parameter.Value=value;returnparameter;}publicDbParameterCreateParameter(stringname){DbParameterparameter=CreateParameter();parameter.ParameterName=name;returnparameter;}publicDbParameterCreateParameter(){returnnewSqlParameter();}publicTExecuteScalar(stringsql,paramsDbParameter[]parameters){using(DbConnectionconnection=CreateConnection()){DbCommandcmd=CreateCommand();cmd.Connection=connection;cmd.CommandText=sql;cmd.Parameters.AddRange(parameters);connection.Open();objecto=cmd.ExecuteScalar();connection.Close();return(T)Convert.ChangeType(o,typeof(T));}}publicDbDataReaderExecuteReader(stringsql,paramsDbParameter[]parameters){DbConnectionconnection=CreateConnection();DbCommandcmd=CreateCommand();cmd.Connection=connection;cmd.CommandText=sql;cmd.Parameters.AddRange(parameters);connection.Open();returncmd.ExecuteReader(CommandBehavior.CloseConnection);}publicintExecuteNoneQuery(stringsql,paramsDbParameter[]parameters){using(DbConnectionconnection=CreateConnection()){DbCommandcmd=CreateCommand();cmd.Connection=connection;cmd.CommandText=sql;cmd.Parameters.AddRange(parameters);connection.Open();intnum=cmd.ExecuteNonQuery();connection.Close();returnnum;}}publicListGetDataList(stringsql,paramsDbParameter[]parameters){Listlist=newList();using(DbDataReaderreader=ExecuteReader(sql,parameters)){while(reader.Read()){Hashtablehs=newHashtable();for(inti=0;i