C# WinForm 内部连接致命错误
问题描述:在一窗口生成考勤时估计要8分钟左右,在生成考勤的同时我打开另一窗口查询加班单(查询的数据不多,最多只有10条),就报"内部连接致命错误",请教数据连接是不是被独占,当前只能一个连接还是其它的什么原因?
生成考勤代码:
int result = 0;
try
{
if (myConn.State == ConnectionState.Closed)
{
myConn.ConnectionString = ANDON.SqlHelper._fuzhuSQLDB;
myConn.Open();
}
SqlParameter[] myPara = {
new SqlParameter("@BeginDate",SqlDbType.VarChar,8),
new SqlParameter("@EndDate",SqlDbType.VarChar,8),
new SqlParameter("@ALLYG",SqlDbType.VarChar,5),
new SqlParameter("@CURRENTYG",SqlDbType.VarChar,5000)
};
myPara[0].Value = strBeginDate;
myPara[1].Value = strEndDate;
myPara[2].Value = strALLYG;
myPara[3].Value = strCURRENTYG;
result = ANDON.SqlHelper.ExecmyCmd(myPara, "ExecProceJBKQ", CommandType.StoredProcedure, myConn);
}
catch (Exception Ex)
{
throw Ex;
}
finally
{
if (myConn.State == ConnectionState.Open)
{
myConn.Close();
myConn.Dispose();
}
}
return result;
以下是查询加班单代码:
dsCMSJA myCMSJA = new dsCMSJA();
myCMSJA.EnforceConstraints = false;
try
{
if (myConn.State == ConnectionState.Closed)
{
myConn.ConnectionString = ANDON.SqlHelper._fuzhuSQLDB;
myConn.Open();
}
myCMSJA = (dsCMSJA)ANDON.SqlHelper.FillDataSet(myCMSJA, new string[] { "CMSJA" }, SQLQuery.queryCMSJA(GetRecords, GetCondition, GetOrderBy), myConn);
}
catch (SqlException Ex)
{
throw Ex;
}
finally
{
if (myConn.State == ConnectionState.Open)
{
myConn.Close();
}
}
return myCMSJA;