UPGRADE-MCSD-MS-NET-Skills-to-MCPD-Entpse-App-Dvlpr-Pt1-(70-553-VB).pdf - Microsoft 70-553-VB UPGRADE-MCSD MS.NET Skills to MCPD Entpse App Dvlpr Pt1

UPGRADE-MCSD-MS-NET-Skills-to-MCPD-Entpse-App-Dvlpr-Pt1-(70-553-VB).pdf

This preview shows page 1 - 4 out of 7 pages.

70-553-VB Microsoft UPGRADE-MCSD MS.NET Skills to MCPD Entpse App Dvlpr Pt1
Answer: D QUESTION: 79 A Windows Forms application contains the following code segment. Dim SQL As String = "SELECT EmployeeID, LastName, FirstName FROM Employees" Dim da As New SqlDataAdapter(SQL, connStr) Dim dt As New DataTable() da.MissingSchemaAction = MissingSchemaAction.AddWithKey Dim bld As New SqlCommandBuilder(da) da.Fill(dt) The application allows the user to add rows to the data table. The application will propagate these additions to the database. If the addition of any row fails, the other rows must still be added. The code must log how many new rows failed to be added. You need to propagate the additions to the database and log a failed count. Which code segment should you use? A. da.ContinueUpdateOnError = Trueda.Update(dt)Dim dtErrors As DataTable = dt.GetChanges(DataRowState.Unchanged)Trace.WriteLine((dtErrors.Rows.Count.ToString() + " rows not added.")) B. da.ContinueUpdateOnError = Falseda.Update(dt)Dim dtErrors As DataTable = dt.GetChanges(DataRowState.Unchanged)Trace.WriteLine((dtErrors.Rows.Count.ToString() + " rows not added.")) C. da.ContinueUpdateOnError = Trueda.Update(dt)Dim rows As DataRow() = dt.GetErrors()Trace.WriteLine((rows.Length.ToString() + " rows not added.")) D. da.ContinueUpdateOnError = Falseda.Update(dt)Dim rows As DataRow() = dt.GetErrors()Trace.WriteLine((rows.Length.ToString() + " rows not added.")) Answer: C QUESTION: 80 A Windows Forms application loads an XmlDocument from a file named books.xml. You need to validate the XML against a schema that is contained in the books.xsd file when the XML loads. What should you do? 46

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture