How does sqlcommand builder work?

Question

I have an old asp.net project in which DataAdapters have havily used, i want to know how does update() work.