Suppse I created a Oracle table with a name as emp.
And I have two column names as ‘ id ‘ and ‘ ename ‘.
Here datatype of id is number and ename datatype is navarchar.

If we are using OrcaleDatabse we have to Include NameSpace as Using System.Data;
And Using System.Data.OracleClient.

Below is a Comple Program for inserting values in a Oracle table .

Using System;
Using System.Data;
Using System.Data.OracleClient;

NameSpace OrcleExample
{
      Class A
      {
              Static Void Main(String[ ]args)
              {
    OracleConnection conn=new OrcleConnection(“your DataSource”);
     Conn.Open();
     OracleCommand cmd=new OracleCommand(“insert into emp(id,ename) values(10,’Austin’);
     cmd.ExecuteNonQuery();

    Console.WriteLine(“One Row Inserted Sucessfully”);
     Console.Read();
              }
       }
}

Note: If your Inserting a values using command classes then you have to use ExecuteNonQuery() method with the command object .