System.Data.OracleClient – Oracle Insert Record 使用方法
using System.Data.OracleClient; using System.Data; private void OracleInsertConnection() { String ConnectionString = "User Id=<User ID>;Password=<User Password>; Data Source=<Server IP>; Unicode=True"; OracleConnection conn = new OracleConnection(ConnectionString); conn.Open(); String SQLStatement = "INSERT INTO Test (ID, ITEM_1, ITEM_2, ITEM_3) VALUES (14, 11, 2131, 21314)"; OracleCommand cmd = new OracleCommand(SQLStatement, conn); cmd.ExecuteNonQuery(); conn.Dispose(); cmd.Dispose(); conn.Close(); } |