#region 打开数据库连接
///
/// 打开数据库连接.
///
private bool Open()
{
// 打开数据库连接
if (con == null)
{
con = new OracleConnection("data source=DB_192.168.1.100;user=user;password=pwd;");
}
else
{
con.Close();
con.Dispose();
con = new OracleConnection("data source=DB_192.168.1.100;user=user;password=pwd;");
}
if (con.State == System.Data.ConnectionState.Closed)
try
{
con.Open();
}
catch (OracleException e)
{
con.Close();
con.Dispose();
MessageBox.Show(e.Message.ToString(), "数据库连接错误!", MessageBoxButtons.OK, MessageBoxIcon.Error);
return false;
}
return true;
}
#endregion
要先添加OracleClient引用,连接代码如下:
private OracleConnection con; //创建连接对象
#region 打开数据库连接
///
/// 打开数据库连接.
///
private bool Open()
{
// 打开数据库连接
if (con == null)
{
con = new OracleConnection("data source=DB_192.168.1.100;user=user;password=pwd;");
}
else
{
con.Close();
con.Dispose();
con = new OracleConnection("data source=DB_192.168.1.100;user=user;password=pwd;");
}
if (con.State == System.Data.ConnectionState.Closed)
try
{
con.Open();
}
catch (OracleException e)
{
con.Close();
con.Dispose();
MessageBox.Show(e.Message.ToString(), "数据库连接错误!", MessageBoxButtons.OK, MessageBoxIcon.Error);
return false;
}
return true;
}
#endregion
mark