OracleConnection conn = new OracleConnection("Provider=OraOLEDB.Oracle;Data Source=test;User Id=test;Password=");
string sql = "insert into ass_main (add_user) values('sdfkkkkkkkk')";
OracleCommand mycommand = new OracleCommand(sql, conn);
mycommand.ExecuteNonQuery();oracle连接应该是没有问题的,查询数据可以在页面显示,但是要插入数据怎么插不进去? 也没有报错,PL/SQL查看并没插入新数据,insert into update 这类语句怎么写啊?
http://bbs.csdn.net/topics/80145578
insert into ass_main (add_user) values('sdfkkkkkkkk')
1.pl_sql 如果只是简单的执行的话好像还有一个Commit过程
2.锁表了。
照猫画虎改了一下,还是不行OracleConnection conn = new OracleConnection("Provider=OraOLEDB.Oracle; Source=test;User Id=test;Password=test");
conn.Open();
string sql = "insert into ass_main (add_user) values('sdfkkkkkkkk')";
OracleCommand mycommand = conn.CreateCommand();
OracleTransaction myTrans = conn.BeginTransaction(IsolationLevel.ReadCommitted);
mycommand.Transaction = myTrans;
mycommand.CommandText = sql;
mycommand.ExecuteNonQuery();
myTrans.Commit();
Provider=OraOLEDB.Oracle 这个在网上有很多写法
Provider=System.Data.OracleClient
不知道什么意思?我是安装了oracle客户端的,也配置了客户端连接