title: Insert Data Set into Oracle Table
body: <p>I am trying to insert all the records from my data table into oracle table.  I have figured out how to insert a single record, however how do I go about inserting multiple records.  The biggest problem here is that the order of columns in dataset does not match the order of columns in oracle table.</p>
  
  <p>Here is the code I am using to insert a single record:</p>
  
  <pre><code>OdbcCommand cmd = new OdbcCommand();
      try
      {
          cmd.Connection = getDBConnection(); //This calls another method that just gets the connection to database
          cmd.CommandType = CommandType.Text;
          cmd.CommandText = "INSERT INTO MY_INSERT_TEST(NAME) VALUES(\'Test 1\')";
          cmd.ExecuteNonQuery();
          cmd.Connection.Close();
          cmd.Dispose();
      }
      catch
      {
          cmd.Connection.Close();
          cmd.Dispose();
      }
  </code></pre>
  
  <p>so how do I modify these to add all records from the data set?</p>