How does sqlcommand builder work?

Ami Kar

5y939Learn iOS Programming

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

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sachin Singh5y ago
Accepted answer
SqlDataApater just needs all T-Sql query in order to save changes to databased , if you have modified some row or deleted some row from database then row state changes to modified and deleted accordingly you need to provide update and delete SQL query to data adapter,
To save time we use SqlCommandBuilder which automatically generates required T-SQL statements based on select statement you provide to data adpater and thus the data adapter's Update() command works.

please go through https://www.sharpencode.com/article/ADONET/sqlcommandbuilder
Saravanan Ganesan3y ago
The DataAdapter in ASP.NET is used to interact with a database using a DataSet. The Update() method is used to synchronize changes made to the DataSet with the actual database. It works as follows:
1. Data is retrieved from the database into the DataSet.
2. Changes made in the DataSet (inserts, updates, deletes) are tracked.
3. When you call Update(), the DataAdapter generates SQL commands (INSERT, UPDATE, DELETE) based on the changes.
4. These SQL commands are executed against the database, applying changes to the corresponding tables.
The DataAdapter automatically generates SQL commands based on the original SELECT command and the database schema. It's a convenient way to update the database with changes made in the DataSet, simplifying the process of data manipulation in ASP.NET applications.
Cr Bhargavi3y ago
T-Sql query is needed in order to save changes to do the changes of some row or when it deletes the data