Your application accesses a table named Orders from a Microsoft SQL Server database. The Orders table includes a primary key. You use DbDataAdapter to fill a DataTable with rows selected from the Orders table. You must configure the DbDataAdapter so that you can use it to update the Orders table with changes that your application makes to the DataTable.

What should you do?

 Posted by Rajkatie on 9/9/2012 | Category: ADO.NET Interview questions | Views: 1206 | Points: 40
Select from following answers:
  1. Use a CommandBuilder to generate SQL statements automatically for update.
  2. Call the DataTable.AcceptChanges method before calling the DbDataAdapter.Update method.
  3. Set the MissingSchemaAction property to AddWithKey.
  4. All Above

Show Correct Answer

Source: MeasureUp.Com | | Alert Moderator 

Comments or Responses

Login to post response