1:先下载oracle的ODAC,然后安装里面的odp.net.
2:引用odp.net.的Oracle.DataAccess.dll,并将文件添加到软件根目录。
3:连接数据库代码
string conStr = "User id=mes;password=ead;Data Source=10.127.1.1:1521/mesprd";
OracleConnection conn = new OracleConnection(conStr);
try
{
conn.Open();
MessageBox.Show("连接数据库成功,状态信息:" + conn.State.ToString());
}
catch (Exception ex)
{
MessageBox.Show("连接失败,失败信息:" + ex.ToString());
}
finally
{
conn.Close();
}
4:读写数据库代码
using (OracleCommand comm = new OracleCommand("select * from mespro.sfc_wip_log", conn))
{
using (OracleDataReader rdr = comm.ExecuteReader())
{
rdr.Read();
textBox1.Text = "UserName:" + rdr.GetString(0);
rdr.Close();
}
}