Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
421 views
in Technique[技术] by (71.8m points)

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

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

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)

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

Take a look at this example .


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...