The data-driven application is the most common type of application that you will be working with, and this importance is echoed in the XML Web Services exam. In this chapter, you will round out your coverage of data technologies by looking at how you can implement XML web services that both expose and consume data. | Q A MCAD MCSD MICROSOFT CERTIFIED APPLICATION DEVELOPER MICROSOFT CERTIFIED SOLUTION DEVELOPER Consuming and Manipulating Data CERTIFICATION OBJECTIVES 6 Consuming and Manipulating Data Accessing and Manipulating Data from a Microsoft SQL Server Database by Creating and Using Ad Hoc Queries and Stored Procedures Creating and Manipulating DataSets Accessing and Manipulating XML Data Two-Minute Drill Self Test 2 Chapter 6 Consuming and Manipulating Data T . . . . . . . he data-driven application is the most common type of application that you will be working with and this importance is echoed in the XML Web Services exam. In this chapter you will round out your coverage of data technologies by looking at how you can implement XML web services that both expose and consume data. The move to use XML documents both as the source and the client storage of data means that you need to look at how you can create an XML document from an existing DataSet and directly from Microsoft SQL Server. This chapter focuses mainly on the theory of and SQL. Exercises are included to show the code and techniques needed to understand the questions on the exam. CERTIFICATION OBJECTIVE Data Access with has evolved from a combination of DAO Data Access Objects VBSQL Visual Basic SQL RDO Remote Data Objects and ADO ActiveX Data Objects but it does not share the same programming model as these technologies even though most of the functionality is the same. The different data-access technologies represent the history of how Microsoft has supported database developers over the different versions of development tools and operating systems. DAO was introduced with VB 3 to support Access development VBSQL was a technology that allowed VB programmers to access SQL Server data RDO provided for disconnected recordsets and ADO gave us COM and data. is based on a disconnected DataSet that is stored with the client while earlier technologies
