title: Updating a Sharepoint List from Powershell
body: <p>I can modify a new datarow in Powershell but it will not update the Sharepoint List on the site itself.</p>
  
  <p>Here is a bit of my code </p>
  
  <p>Here i fill my dataset with table info</p>
  
  <pre><code>$connString = 'Provider=Microsoft.ACE.OLEDB.12.0;WSS;IMEX=2;RetrieveIds=Yes;DATABASE=https://sharepoint/;LIST={6d552622-3333-4444-9999-234d32d32d3};'
  $spConn = new-object System.Data.OleDb.OleDbConnection($connString)
  $spConn.open()
  $qry="select * from myList"
  $cmd = new-object System.Data.OleDb.OleDbCommand($qry,$spConn)
  $da = new-object System.Data.OleDb.OleDbDataAdapter($cmd)
  $dataSet = new-object System.Data.DataSet
  $sp = $dataSet.Tables.Add("Table")
  $da.fill($sp)
  </code></pre>
  
  <p>Here i add a new datarow</p>
  
  <pre><code> $row = $sp.NewRow()
   $sp.Rows.Add($row)
   $row["Title"] = "Foo"
  </code></pre>
  
  <p>And here i try to update the Sharepoint List</p>
  
  <pre><code> $da.Update($sp)
  </code></pre>
  
  <p>It does not let me update, any help or guidence would be great.</p>
  
  <p>Thanks</p>