c# - How to update data from datatable to sql table?

Question

I have an sql table with

ID(unique) Name status
1          A    0
2          B    0

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

After that, I need to update them back to sql.

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.

Not very good, I know. That's why I am asking, is there any better way to do that?

Answer 1

You can update the content of the table back working with a CommandBuilder .

Take a look at this example .