Microsoft Visual Studio 2005,C#,网上下了个oracle_net.msi安装。
连接oracle9i,出错提示如下:
命名空间“System.Data”中不存在类型或命名空间名称“OracleClient”(是缺少程序集引用吗?)
这怎么搞啊?刚学asp.net,大侠指点。程序代码如下。
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;using System.Data.OracleClient;public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
OracleConnection conn = new OracleConnection();
OracleConnectionString = "Data Source=orclerp;user=taizhou_qy;password=11hello!";
conn.Open();
string strSelect = "select exchange_no,accept_sum from taizhou.sto_payment_detail where exchange_no like '100706%' and payment_no='29'";
OracleCommand cmd = new OracleCommand(strSelect, conn);
OracleDataReader dr = new cmd.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();
conn.Close();
}
}
连接oracle9i,出错提示如下:
命名空间“System.Data”中不存在类型或命名空间名称“OracleClient”(是缺少程序集引用吗?)
这怎么搞啊?刚学asp.net,大侠指点。程序代码如下。
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;using System.Data.OracleClient;public partial class Default2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
OracleConnection conn = new OracleConnection();
OracleConnectionString = "Data Source=orclerp;user=taizhou_qy;password=11hello!";
conn.Open();
string strSelect = "select exchange_no,accept_sum from taizhou.sto_payment_detail where exchange_no like '100706%' and payment_no='29'";
OracleCommand cmd = new OracleCommand(strSelect, conn);
OracleDataReader dr = new cmd.ExecuteReader();
GridView1.DataSource = dr;
GridView1.DataBind();
conn.Close();
}
}
然后选择添加引用,再选择.net选项卡,找到System.Data.OracleClient确定就行