馬仔驚自己唔記得要留既notes

二月 11, 2012

Oracle Insert Record 使用方法

Filed under: ASP.NET C# — Tags: , , , , , , , , — vectus2001 @ 10:07 am

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

Theme: Shocking Blue Green. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.