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;
}
public static bool Execute(Oracle.DataAccess.Client.OracleCommand myCMD,string connectString)
{
Oracle.DataAccess.Client.OracleConnection myConn = new Oracle.DataAccess.Client.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;
}
当用第一个方法也就是说OracleCommand 这个创建的myCMD可以执行成功
而第二个方法Oracle.DataAccess.Client.OracleCommand 这个创建的myCMD执行不成功报Connection must be open for this operation的异常这是怎么回事啊
