62,243
社区成员
发帖
与我相关
我的任务
分享orcale数据访问
对orcale数据库的有些操作会出现这个异常
Connection must be open for this operation
是怎么回事啊
Connection must be open for this operation
是怎么回事啊
...全文
请发表友善的回复…
发表回复
my51f12w 2010-01-12
- 打赏
- 举报
调用公用方法的
my51f12w 2010-01-12
- 打赏
- 举报
public static bool Execute(OracleCommand myCMD,string connectString)
{
OracleConnection myConn = new OracleConnection(connectString);
myCMD.Connection = myConn;
try
{
myConn.Open();
int rec = myCMD.ExecuteNonQuery();
if(rec > 0)
return true;
else
return false;
}
catch(Exception exp)
{
AdmExceptionHandling.ExceptionHandling("连接数据库失败！",exp.ToString());
}
finally
{
if( ConnectionState.Open == myConn.State )
{
myConn.Close();
}
}
return false;
}
{
OracleConnection myConn = new OracleConnection(connectString);
myCMD.Connection = myConn;
try
{
myConn.Open();
int rec = myCMD.ExecuteNonQuery();
if(rec > 0)
return true;
else
return false;
}
catch(Exception exp)
{
AdmExceptionHandling.ExceptionHandling("连接数据库失败！",exp.ToString());
}
finally
{
if( ConnectionState.Open == myConn.State )
{
myConn.Close();
}
}
return false;
}
灵雨飘零 2010-01-12
- 打赏
- 举报
应该是链接问题
灵雨飘零 2010-01-12
- 打赏
- 举报
帮顶！！
sf
sf
huwei12345 2010-01-12
- 打赏
- 举报
连接没打开呗
