Oracle Data Provider for .NET 学习笔记
无名!
这个作者很懒,什么都没留下…
展开
-
OracleDataAdapter Class
// C#public static void AdapterUpdate(string connStr){string cmdStr = "SELECT EMPNO, EMPNAME, SALARY FROM EMPINFO";//create the adapter with the selectCommand txt and the//connection stringOracleDat原创 2004-11-18 10:29:00 · 1289 阅读 · 0 评论 -
在数据库中开始一个事务。
下面的示例创建一个 OracleConnection 和一个 OracleTransaction。它演示了如何使用 BeginTransaction、Commit 和 Rollback 方法。public void RunOracleTransaction(string myConnString){ OracleConnection myConnection = new OracleCon原创 2005-03-15 10:39:00 · 1196 阅读 · 0 评论 -
在对数据库的操作中使用parameters
string conStr = "User Id=scott;Password=tiger;Data Source=oracle"; // Create the OracleConnectionOracleConnection con = new OracleConnection(conStr); con.Open(); // Create the OracleCommandOracleComma原创 2004-11-16 18:25:00 · 1256 阅读 · 0 评论 -
OracleCommandBuilder
public static void BuilderUpdate(string connStr){string cmdStr = "SELECT EMPNO, EMPNAME, JOBDESCRIPTION FROM EMPINFO";//create the adapter with the selectCommand txt and the//connection stringOracle原创 2004-11-18 09:17:00 · 3305 阅读 · 0 评论 -
Array Binding
...// Create an array of values that need to be insertedint[] myArrayDeptNo = new int[3]{10, 20, 30}; // Set the command text on an OracleCommand objectcmd.CommandText = "insert into dept(deptno) va原创 2004-11-16 09:23:00 · 895 阅读 · 0 评论 -
SafeMapping
CREATE TABLE empInfo (empno NUMBER(4) PRIMARY KEY,empName VARCHAR2(20) NOT NULL,hiredate DATE,salary NUMBER(7,2),jobDescription Clob,byteCodes BLOB);===================================// C#// The foll原创 2004-11-18 14:21:00 · 1171 阅读 · 0 评论 -
CreateCommand--通过OracleConnection创建和返回OracleCommand对象
// C#// Uses connection to create and return an OracleCommand object....string ConStr = "User Id=myschema;Password=mypassword;" +"Data Source=oracle;";OracleConnection con = new OracleConnection(Con原创 2004-11-18 09:39:00 · 2081 阅读 · 0 评论 -
Clone 创建一个对象的副本
// C#...OracleConnection con = new OracleConnection(ConStr);con.Open();...//Need a proper casting for the return value when clonedOracleConnection con_cloned = (OracleConnection) con.Clone(); PS:真不知原创 2004-11-18 09:36:00 · 979 阅读 · 0 评论 -
运用事务
// Starts a transaction and inserts one record. If insert fails, rolls back// the transaction. Otherwise, commits the transaction....string ConStr = "User Id=myschema;Password=mypassword;" +"Data Sour原创 2004-11-18 09:29:00 · 774 阅读 · 0 评论 -
使用存储过程的一个小例子
Public Overloads Sub Update(ByVal authorityArr As IList) log.Debug("Update a record in table TBL_M_AUTHORITY") Dim connection As OracleConnection = New OracleConnection(OraHelp原创 2005-03-15 10:59:00 · 817 阅读 · 0 评论