title: How would I insert data into an Access table using vb.net?
body: <p>I want to insert a new row into an Access database. I'm looking at doing something like: </p>
  
  <pre><code>oConnection = new Connection("connectionstring")
  oTable = oCennection.table("Orders")
  oRow = oTable.NewRow
  oRow.field("OrderNo")=21
  oRow.field("Customer") = "ABC001"
  oTable.insert
  </code></pre>
  
  <p>Which seems to be a sensible way of doing things to me.  </p>
  
  <p>However, All examples I look for on the net seem to insert data by building SQL statements, or by creating a "SELECT * From ...", and then using this to create a multitude of objects, one of which appears to allow you to ...<br>
  - populate an array with the current contents of the table.<br>
  - insert a new row into this array.<br>
  - update the database with the changes to the array.  </p>
  
  <p>What's the easiest way of using vb.net to insert data into an Access database?<br>
  Is there a method I can use that is similar to my pCode above? </p>