I am working on an Art Flash Card program and need to use XML as my datasource. I'm pretty sure that I can use SQL statements to work with the data once I make the connection but I am not sure how to make the connection in the first place.
This is my XML File. It is named C:\FlashCards\FlashCardData.xml
I have never worked with XML as a datasource before but I think that is the correct format for doing what I need.Code:<?xml version="1.0" encoding="utf-8" ?> <ArtWork> <Art> <ID>1</ID> <title>Blue World</title> <Artist>Steve Jackson</Artist> <Path>c:\artwork\blu01.jpg</Path> <Style>Abstract</Style> </Art> <Art> <ID>2</ID> <title>The Body</title> <Artist>George Willard</Artist> <Path>c:\artworkbo01.jpg</Path> <Style>Modern</Style> </Art> <Art> <ID>3</ID> <title>Flashlight</title> <Artist>Bob Miller</Artist> <Path>c:\artqorkfl01.jpg</Path> <Style>Modern</Style> </Art> </ArtWork>




Reply With Quote