title: How to update data from datatable to sql table?
body: <p>I have an sql table with </p>
  
  <pre><code>ID(unique) Name status
  1          A    0
  2          B    0
  </code></pre>
  
  <p>In my code, I retrieve all data into a data table and do some coding.
  Based on the results, I will change the results from 0 to 1 or 2</p>
  
  <p>After that, I need to update them back to sql.</p>
  
  <p>My idea is to create a temp table, insert every row into that .. and then update them to the real sql table, delete the temp table.</p>
  
  <p>Not very good, I know. That's why I am asking, is there any better way to do that?</p>