orcle的连接

[zhouzhiyonggm]

连接oracle数据库时有哪些引用集？
在加了system.data system.data.OrcleClient后还是不行？
在调试时会报错

[红街咖啡]

报了什么？

[jackyuen1]

可以了，是不是程序有错？

[vrhero]

安装Oracle Client没有？Oracle可不像SQL Server那么容易用...

[WizardWu]

Oracle 11g 学习笔记
http://www.cnblogs.com/WizardWu/archive/2008/11/25/1340867.html
http://www.cnblogs.com/WizardWu/archive/2008/11/27/1342174.html
http://www.cnblogs.com/WizardWu/archive/2008/11/28/1343100.html
http://www.cnblogs.com/WizardWu/archive/2008/11/30/1344096.html
http://www.cnblogs.com/WizardWu/archive/2008/12/07/1349665.html

[wuyq11]

using System.Data.OracleClient;
string ConnectionString="Data Source=test;user=system;password=manager;";
using(OracleConnection conn=new OracleConnection(ConnectionString))
{
conn.Open();
OracleCommand cmd=conn.CreateCommand();
cmd.CommandText="";
OracleDataReader odr=cmd.ExecuteReader();
while(odr.Read())
{

}
odr.Close();
conn.Close();
}

[Adechen]

同楼上的，

[myrroom]

这是PetShop中用的链接Orcle的

string sqlSelect = "SELECT Cart.ItemId, Cart.Name, Cart.Type, Cart.Price, Cart.CategoryId, Cart.ProductId, Cart.Quantity FROM Profiles, Cart WHERE Profiles.UniqueID = Cart.UniqueID AND Profiles.Username = :Username AND Profiles.ApplicationName = :ApplicationName AND IsShoppingCart = :IsShoppingCart";

			OracleParameter[] parms = {						   
				new OracleParameter(":Username", OracleType.VarChar, 256),
				new OracleParameter(":ApplicationName", OracleType.VarChar, 256),
				new OracleParameter(":IsShoppingCart", OracleType.VarChar, 1)};
			parms[0].Value = userName;
			parms[1].Value = appName;
			parms[2].Value = OracleHelper.OraBit(isShoppingCart);

			OracleDataReader dr = OracleHelper.ExecuteReader(OracleHelper.ConnectionStringProfile, CommandType.Text, sqlSelect, parms);

			IList<CartItemInfo> cartItems = new List<CartItemInfo>();

			while(dr.Read()) {
				CartItemInfo cartItem = new CartItemInfo(dr.GetString(0), dr.GetString(1), dr.GetInt32(6), dr.GetDecimal(3), dr.GetString(2), dr.GetString(4), dr.GetString(5));
				cartItems.Add(cartItem);
			}
			dr.Close();
			return cartItems;

[Lovely_baby]

using System.Data.OracleClient;
using System.Data;

[zhouzhiyonggm]

谢谢，看了你们的意见，问题已解决。