You use SqlDataAdapter to load a DataTable from a Microsoft SQL Server database table. Your code makes several changes to the DataTable and then calls SqlDataAdapter.Update to update the database. You want to ensure that if a call to the InsertCommand, UpdateCommand, or DeleteCommand throws an exception, the update continues.

What should you do ?

 Posted by Rajkatie on 10/26/2012 | Category: ADO.NET Interview questions | Views: 2125 | Points: 40
Select from following answers:
  1. Set the adapter's ContinueOnUpdateError property to True and Add an event handler to the RowsUpdated event to override update termination.
  2. Set the adapter's AcceptChangesDuringFill property to True.
  3. Set the adapter's AcceptChangesDuringUpdate property to True.
  4. All Above

Show Correct Answer

Source: | | Alert Moderator 

Comments or Responses

Login to post response