System.Data.OracleClient – Oracle Insert Record 使用方法

 
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();
 
   }