我这样写好像有问题:当之前连接正常,然后我把服务关闭后,还是提示连接正常,open不出异常,郁闷了。请大侠指导publicstaticboolChkOCDBLink(stringconnString){boolresult=true;Or...
我这样写好像有问题:
当之前连接正常,然后我把服务关闭后,还是提示连接正常,open不出异常,郁闷了。请大侠指导
public static bool ChkOCDBLink(string connString)
{
bool result = true;
OracleConnection conn = null;
try
{
conn = new OracleConnection(connString);
conn.Open();
if (conn.State == ConnectionState.Open)
{
result = true;
conn.Close();
}
else
{
result = false;
}
}
catch (OracleException ex)
{
System.Diagnostics.Debug.WriteLine(ex.ToString());
result = false;
}
finally
{
if (conn != null)
{
conn.Dispose();
conn = null;
}
}
return result;
}
展开