Programs Knowledge

using System.Data.OracleClient;//取得"Oracle相關物件"必需的

//連線設定分別需要輸入HOST、PORT、SID、User Id and Password

//而System_Identity(SID)查詢方法有2種：

//1.在Oracle的安裝目錄下，例如D:\oracle\product\10.2.0\db_1\dbs，看文件名如SPFILEXE.ORA，接下來將文件

    名稱的開頭＂SPPILE＂拿掉，剩下的字串為＂XE＂就是SID

//2.在PL/SQL中輸入查詢語句：＂select instance_name from v$instance; ＂即可

 OracleConnection oConn = new OracleConnection ("Data Source=(DESCRIPTION=(ADDRESS_LIST=

    (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.111)(PORT=1521)))(CONNECT_DATA=(SID=XE)));

     User Id=system;Password=oracle");

oConn.Open();

string queryStr = "update TableName set ColumnName2 = 'test' where ColumnName1 = '1'";

 OracleTransaction transaction = null;

transaction = oConn.BeginTransaction();

OracleCommand command = oConn.CreateCommand();

command.CommandText = queryStr;

command.Transaction = transaction;

command.ExecuteNonQuery();

transaction.Commit();

if(transaction != null)

    transaction.Dispose();

oConn.Close();