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?
See Question&Answers more detail:
os 与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…