在vs2010中使用c#,新建一个windows窗体应用程序,添加按钮button1和datagriveview,连接本地64位oracle数据库(操作系统是window2008 64位,也安装了oracle 11g 64位数据库和客户端),代码如下,运行后出现错误。添加了oracle 11g client安装目录下的oracle.dataaccess.client.dll 引用。
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Oracle.DataAccess.Client;namespace TurnFC
{
public partial class Form1 : Form
{
OracleConnection myConn;
String connectionString;
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
connectionString = "Data Source=orcl;User ID=system;PassWord=system;";
// 连接oracle
myConn = new OracleConnection(connectionString);
try
{
myConn.Open(); }
catch (Exception ee)
{
MessageBox.Show(ee.Message.ToString());
}
string sqlstr = "select * from user_users ";
OracleDataAdapter sda = new OracleDataAdapter(sqlstr, myConn);
DataSet myds = new DataSet();
sda.Fill(myds); GridView1.DataSource = myds;
GridView1.Refresh(); }
}
}
错误提示:
未能加载文件或程序集“Oracle.DataAccess, Version=2.112.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342”或它的某一个依赖项。试图加载格式不正确的程序。
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using Oracle.DataAccess.Client;namespace TurnFC
{
public partial class Form1 : Form
{
OracleConnection myConn;
String connectionString;
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
connectionString = "Data Source=orcl;User ID=system;PassWord=system;";
// 连接oracle
myConn = new OracleConnection(connectionString);
try
{
myConn.Open(); }
catch (Exception ee)
{
MessageBox.Show(ee.Message.ToString());
}
string sqlstr = "select * from user_users ";
OracleDataAdapter sda = new OracleDataAdapter(sqlstr, myConn);
DataSet myds = new DataSet();
sda.Fill(myds); GridView1.DataSource = myds;
GridView1.Refresh(); }
}
}
错误提示:
未能加载文件或程序集“Oracle.DataAccess, Version=2.112.1.0, Culture=neutral, PublicKeyToken=89b483f429c47342”或它的某一个依赖项。试图加载格式不正确的程序。
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货