XML Data
-
Please forgive my ignorance...I am trying to learn XML while working on a project that may not be able to be done...not sure. The goal of my project is to create a configuration file that feeds a scheduled program details about reports that need to be run from a database. The details of the "QUERIES.XML" file should contain a "Report" Element. The "Report" element should contain a "Title", "Query", and "Recipients" elements. The Title and Query elements are good. I am having trouble reading the recipients though. The recipients element should have two elements, "Name" and "Address" [e-mail address]. I have tried to create a DataSet but that only reads the Title and Query elements, but does not pick up any of the recipient information. Here is a sample of my XML file, which I am not even sure is correct. I have been searching all day until I am cross-eyed and I don't know what I am missing. Test Report select Col1, Col2, Col3 FROM Table1 WHERE Criteria='this' John Smith
Joe Williams
I have also tried a variation of the file that looks like this: Test Report select Col1, Col2, Col3 FROM Table1 WHERE Criteria='this'
I am not looking for anyone to write code for me...I need some direction on where to go so I can learn and improve my skill. Thanks
-
Please forgive my ignorance...I am trying to learn XML while working on a project that may not be able to be done...not sure. The goal of my project is to create a configuration file that feeds a scheduled program details about reports that need to be run from a database. The details of the "QUERIES.XML" file should contain a "Report" Element. The "Report" element should contain a "Title", "Query", and "Recipients" elements. The Title and Query elements are good. I am having trouble reading the recipients though. The recipients element should have two elements, "Name" and "Address" [e-mail address]. I have tried to create a DataSet but that only reads the Title and Query elements, but does not pick up any of the recipient information. Here is a sample of my XML file, which I am not even sure is correct. I have been searching all day until I am cross-eyed and I don't know what I am missing. Test Report select Col1, Col2, Col3 FROM Table1 WHERE Criteria='this' John Smith
Joe Williams
I have also tried a variation of the file that looks like this: Test Report select Col1, Col2, Col3 FROM Table1 WHERE Criteria='this'
I am not looking for anyone to write code for me...I need some direction on where to go so I can learn and improve my skill. Thanks
Hi jontyler Here I think you have to create two different data tables for it, and put them into data set. Thanks, Devaang
-
Hi jontyler Here I think you have to create two different data tables for it, and put them into data set. Thanks, Devaang