How does sqlcommand builder work?

Sign in to answer this question.

• 

  Sachin Singh5y agoPosted Jan 29, 2021, 6:47 PM

  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 Ganesan2y agoPosted Sep 24, 2023, 4:56 PM

  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 Bhargavi2y agoPosted Sep 21, 2023, 3:40 AM

  T-Sql query is needed in order to save changes to do the changes of some row or when it deletes the data