visual studio 2005开发web,发现在Debug状态跑,一切ok 但离开visual sudio,手动输入url,结果会报错. 请高手 分析原因

[dawnming]

visual studio 2005开发web,发现在Debug状态跑,一切ok
但离开visual sudio,手动输入url,结果会报错. 请高手 分析原因

private string GetSongEventName(string songId)
{
string songEvtNm = string.Empty;

SqlConnection lobjCon = null;
SqlCommand lobjCmd = null;
SqlDataAdapter sqlda = new SqlDataAdapter();
DataSet ds = new DataSet();

try
{
lobjCmd = new SqlCommand();

lobjCon = CommonDAO.GetSQLConnection(CommonDAO.accountConnStr);
lobjCmd.Connection = lobjCon;
lobjCmd.CommandType = CommandType.StoredProcedure;
lobjCmd.CommandText = "EventSong_SelEventNm";

lobjCmd.Parameters.AddWithValue("@song_id", songId);

sqlda.SelectCommand = lobjCmd;
sqlda.Fill(ds); // 在此处会出错,然后就跑到catch里面去了.

if (ds.Tables[0].Rows.Count > 0)
songEvtNm = Convert.ToString(ds.Tables[0].Rows[0]["event_nm"]);
}
catch (Exception ex)
{
logger.Error("DB error");
logger.Debug(ex.StackTrace);
}
finally
{
//release resource
if (sqlda != null)
{
sqlda.Dispose();
sqlda = null;
}
logger.Debug("release resource");
if (lobjCmd != null)
{
lobjCmd.Dispose();
lobjCmd = null;
}
CommonDAO.CloseSQLConnection(lobjCon);
}

return songEvtNm;
}

[Adechen]

可能是连接条件问题

[dawnming]

catch 是这个样子的.


2009-04-29 13:16:27,031 DEBUG tableview - 場所 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
場所 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
場所 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
場所 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
場所 System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
場所 System.Data.SqlClient.SqlDataReader.get_MetaData()
場所 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
場所 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
場所 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
場所 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
場所 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
場所 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
場所 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
場所 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
場所 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
場所 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
場所 tableview.GetSongEventName(String songId) 場所 e:\project\musicjpdebut\old\planner_tool_old\tableview.aspx.cs:行 377

[dd__dd]

catch捕获啥错误啊？

[bwangel]

很可能是连接条件问题. 再就是数据库权限问题.

[云想慕尘]

catch
catch
catch