The C++ Programming Tutorials: C++ - XML, XSLT and ADO.NET

Home

This tutorial will be divided into two parts: Using XSLT to transform XML documents and Using ADO.NET. The .NET XML is proving to be a useful way of storing and exchanging data, but it isn’t very often that you want to use the data in XML format. You usually need to transform the data into some other form to present it to the end user or use it in programs. By using the classes in the XML namespaces, such as XmlTextReader and XmlDocument, you can obviously write programs that parse XML and turn it into other forms. The problem is that doing so requires programming skills, and in the Web world, a lot of people want to manipulate XML but don’t have such  skills. The EXtensible Stylesheet Language (XSL) was developed to provide a way of transforming XML that doesn’t rely on programming skills. Anyone who understands XML syntax can write a style sheet, which is then applied to an XML document to transform it into some other form.

ADO.NET is the data access API from Microsoft for the Microsoft Windows .NET Framework 1.1. ADO.NET has been optimized to work with .NET to enable distributed applications and services to exchange data easily and reliably. ADO.NET offers two distinct programming models, depending on the type of application you need to build:

1. If your application can obtain and maintain a direct connection to a data source, you can use classes such as OleDbConnection, OleDbCommand, and OleDbDataReader to exchange data with the data source. These classes are superficially similar to previous versions of ADO, but you’ll find many differences when you look into the details.

2. If your application is disconnected from a data source, you can use a DataSet to represent an in-memory cache of data from the data source. DataSet is the most important new class in ADO.NET because it enables you to freely pass data between applications and services residing on different tiers in your architecture.

In this module, you will learn how to use ADO.NET to connect to a data source, execute queries, and perform database update operations. You will also learn how to use a DataSet in a disconnected application. You will see how to fill a DataSet with data from a database and display the data in a DataGrid. ADO.NET provides access to any kind of relational database. The examples in this module try to describe on how to use Microsoft Access. The following are the topics for this Chapter. The .NET network programming (Windows socket/Winsock) with C++/CLI, VB .NET and C# can be found in Windows Network Programming Tutorial for .NET.

1. XML and XSLT C++ 1: What will you learn, Using XSL to Transform XML, Using XPath, The XPathNavigator Class and Using XPathNavigator

2. XML and XSLT C++ 2: Using XPath with XPathNavigator, Basic XPath Syntax, Using XSL, The Basics of XSL Style Sheets and A Very Quick Reference

3. C++ and ADO.NET Accessing Database 1: What is in this module?, What Is ADO.NET?, ADO.NET Data Providers, .NET Framework Data Providers, Core Objects of .NET Framework Data Providers, The .NET Framework Data Provider for SQL Server, The .NET Framework Data Provider for OLE DB, The .NET Framework Data Provider for ODBC and The .NET Framework Data Provider for Oracle

 

 

4. C++ and ADO.NET Accessing Database 2: Choosing a .NET Framework Data Provider, ADO.NET Namespaces, ADO.NET Assemblies, Creating a Connected Application and Connecting to a Database

5. C++ and ADO.NET Accessing Database 3: Creating and Executing a Command, Executing a Command That Modifies Data, Executing Queries and Processing the Results and Creating a Disconnected Application

6. C++ and ADO.NET Accessing Database 4: DataSet Class, DataSet Members and Creating the Form

7. C++ and ADO.NET Accessing Database 5: Creating the Form (continue) and A Very Quick Reference

8. C++ and Web Service 1: What Are Web Services?, A Web Service Scenario, Web Services and the Future, Web Service Architecture, Data Formats and Protocols, What Is SOAP?, Web Service Description, Web Service Discovery, The Web Services Namespaces, WebService Members and Creating a Simple Web Service

9. C++ and Web Service 2: Using the Web Service from a Browser, Using the Web Service from Code, If You’re Not Using Visual Studio .NET and A Very Quick Reference

Best viewed using FireFox, Chrome etc. Worst viewed using IE of any version

Webmaster contact: [contact[@]visualcplusdotnet.com]

Copyright 2019 © Visualcplusdotnet. All rights reserved.

Excellent hosting services provided by MochaHost - The Online Central

| About | Disclaimer | Privacy | Site Index & Project Download | Native C | Contact |