Is running an update query better or making changes in a datatable and updating them later a better option.
And how do we determine which is the better option?

I guess, it doesn't make much difference, it depends on what you want to achieve. An update query equally runs well.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.