title: Linking datagridview to MS Access table with OleDB
body: <p>I want to link datagridview to my existing MS Access table through OleDB.</p>
  
  <p>I have multiple tables named "Groups","Groups2", "Groups3" etc. </p>
  
  <p>By clicking respective button on form (<a href="http://i.imgur.com/v4zJ6U9.png" rel="nofollow">http://i.imgur.com/v4zJ6U9.png</a>) I'm loading one table to datagridview.</p>
  
  <p>I need to link datagridview to Access so I can save any edits I made in datagrid. </p>
  
  <p>I tried this code:
  <a href="http://codepad.org/5PSz4LsB" rel="nofollow">http://codepad.org/5PSz4LsB</a></p>
  
  <p>I'm experimenting with functions  <code>Monday_Click</code>  and <code>Save_Click</code></p>
  
  <blockquote>
    <p>Exception thrown: system.data.oledb.oledbexception Syntax Error in
    UPDATE Statement in da.Update(timetable) command. </p>
  </blockquote>
  
  <p>That's really strange, because OleDbCommandBuilder is supposed to create insert\delete\update queries.</p>
  
  <p>I've tried different solutions from Stackoverflow and other sources, but it didn't work.</p>
  
  <p>Update: Apparently OleDBCommandBuilder doesn't work with '-' in columns names, so I removed this sign from names and it worked just fine.</p>