Reference: .NET Framework Class Library, DataView.RowFilter Property [Visual Basic] Incorrect Answers A: We must use the = operator and construct an expression. We cannot just use a value. C, D: We want to filter the Dataset, not to sort it. Question: 87. (C) You develop a Windows-based application named XYZPurchase that exchanges data with an accounting application. Purchase receives purchase order data from the accounting application in XML format. Users of XYZPurchase review and edit the data. XYZPurchase maintains the data in a DataSet object while users are working. When they are finished making changes, XYZPurchase must create an output file that will be returned to the accounting application. For verification and auditing purposes, the accounting application must receive both the user changes and the original values. Now you need to write code that will create the output file. What should you do? A. Call the DataSet.WriteXmlSchema method and specify a TextWriter object as the argument. B. Call the DataSet.WriteXmlSchema method and specify an XmlWriter object as the argument. C. Call the DataSet.WriteXml method and specify WriteSchema as the XmlWriteMode parameter. D. Call the DataSet.WriteXml method and specify DiffGram as the XmlWriteMode parameter. Answer: D Explanation: A DiffGram is an XML format that is used to identify current and original versions of data elements. Here we use the DataSet.WriteXml method with the Diffgram XmlWriteMode to write the entire DataSet as a DiffGram, including original and current values. Reference: .NET Framework Developer's Guide, DiffGrams .NET Framework Developer's Guide, Writing a DataSet as XML Data [Visual Basic]
Exam Name: Developing Windows-based Applications with Microsoft Visual Basic .NET Exam Type: Microsoft Exam Code: 70-306 Doc Type: Q&A with Explanations Total Questions: 255 Page 64 of 159 Incorrect Answers A, B: We want to write the Dataset in XML format, not as an XML schema. C: The WriteSchema XmlWriteMode writes only the current contents of the DataSet as XML data (with the relational structure as inline XML Schema). Question: 88 (C) You are developing a Windows-based application that logs hours worked by your employees. Your design goals require you to maximize application performance and minimize impact on server resources. You need to implement a SqlCommand object that will send a SQL INSERT action query to a database each time a user makes a new entry. To create a function named LineltemInser, you write the following code: (Line numbers are included for reference only.) 01 Function LineItemInsert(ByVal empid As Integer, _ 02 ByVal projectID As Integer, ByVal hrs As Decimal, _ 03 ByVal cnn As SqlConnection) As Integer 04 Dim SQL As String 05 Dim Ret As Integer 06 SQL = "INSERT INTO TimeEntries " & _ 07 "(EmpID, ProjectID, Hours) VALUES " & 08 "(" & empID & projectID & ", " & hrs & ") " 09 Dim cmd As New SqlCommand(SQL, cnn) 10 11 'Insert new code.
- Spring '16
- .NET Framework, Microsoft Visual Studio