Reading and updating Oracle data tables in C # ____oracle

First, add a reference to the Oracle.DataAccess.dll in the Project reference section.

Using Oracle.DataAccess.Client; Introducing Oracle.dataaccess namespaces

OracleConnection conn = new OracleConnection ("User id=user; Password=pwd;data SOURCE=ORCL ");
Conn.  Open (); Connecting to a database

String strcmd = "SELECT * from TEST";
OracleDataAdapter da = new OracleDataAdapter (STRCMD, conn);
Oraclecommandbuilder cb = new Oraclecommandbuilder (DA);
DataSet ds = new DataSet ();
Da.  Fill (DS); reading data to DataSet
DataTable tab = ds.  Tables[0]; Get DataTable

Update
tab. columns["ID"].  Unique = true; Defines an identity column that is used to locate update rows
tab. rows[0]["NAME" = "test";
Da.  Update (DS); Submit Updates

Insert
DataRow row = tab.  Rows.Add (new object[0]); Add a row
row["ID"] = 2;
row["NAME" = "Insert";
row["DATA"] = new byte[] {1, 2, 3};
Da.   Update (DS); Submit Updates

Conn. Close ();
Conn. Dispose ();