XML and C#

Question

Hi I want to make a simple console application in C# using XML. What I want it to do is: -check to see if the XML file exists. If it does retreive the info from it. If it doesn't create it. -be able to display the info in the XML file. -be able to modify add or delete entries The info in the XML file is simple I'm just doing this for both fun and convenience: what I want to put in the XML file is a list of all my comic books with series name title author number ISBN and publisher. I've been looking around a little but some things I have tried have not worked. Can someone give me a hand or point out a tutorial or something. Thanks for your time!

weapon_x33 · Answer

I'm so proud of myself! ^_^ I was finally able to do it!! wohoooo There's only one thing: this is how I loaded the xml and then changed the format with the xsl template //Load XML file XPathDocument myXPathDoc = new XPathDocument(xmlFile); //Load XSL stylesheet XslTransform myXslTrans = new XslTransform(); myXslTrans.Load(xslFile); //create the output stream XmlTextWriter myWriter = new XmlTextWriter (htmlFile.html null); //do the actual transform of Xml myXslTrans.Transform(myXPathDocnull myWriter); myWriter.Close() ; but VS tells me that the myXslTrans.Transform() is obsolete. It says You should pass XmlResolver to Transform() method...it still runs the program and it works fine but it annoys me when it underlines things so does someone know of a way to fix this issue? Thanks again!

kovan · Answer

try this :D http://www.google.ca/search?q=sort+with+xsl&ie=UTF-8&oe=UTF-8&hl=en&meta=

weapon_x33 · Answer

Say this is the schema XML code. Where do I put the ??? i tried in various places but it tells me that it can't do it. Sometimes I just feel like telling the computer No trust me you'll be fine just try your best to work dammit! ^_^

kovan · Answer

xml is for storing not for displaying if you want to display these u have to use xsl as you mentioned then you use xsl on top of your xml file and u can display it any way you want if you want to sort them for your win32 app then what u can do is you can read this xml file into a dataset and then you can use methods of dataset to play around with the order of data and to read xml files into datasets dataset have .ReadXml method that takes path to a xml file.

weapon_x33 · Answer

Is there a way to sort the XML alphabetically in C#? I was reading that i can do it with the xsl thingy but im not very sure how. This is the XML file i have: Naruto Uzumaki Naruto Kishimoto Masashi Jump Comics 1 4-08-872840-8 Naruto Saiaku no irainin Kishimoto Masashi Jump Comics 2 4-08-872878-5 Gun Blaze West Byu- Banzu Watsuki Nobuhiro Jump Comics 1 4-08-873128-X Naruto blah blah blah blah blah I want to sort them in my app by series (alphabetically) and then by volume number (ascending order). can anyone help? thnx for your time guys ^_^

weapon_x33 · Answer

Ok I was able to get to reading the XML file in two different ways: the one I wrote above which uses System.IO and System.Data and the one you suggested which uses System.Xml. What's the difference between these and what are the pros and cons? Does your version give more power as to what can be done to the XML file? Thanx

weapon_x33 · Answer

I used a slightly different technique. This is what I have so far: using System; using System.Data; using System.IO; namespace MangaList { class Mangas { [STAThread] static void Main(string[] args) { try { //Entry Message Console.WriteLine(:: WELCOME TO DANIELE'S MANGA-LIST APPLICATION::

); Console.WriteLine(Here is a list of commands:
ls - Lists all entries
add - Add an entry
del - Delete an entry
mod - Modify an entry
); string choice = Console.ReadLine(); choice = choice.ToLower(); DataSet ds = new DataSet(); ds.ReadXml(XML_Mangalist.xml); int listNum = 1; if (choice == ls) { //Loop through each row within the DataSet foreach (DataRow dr in ds.Tables[0].Rows) { //Display all information the XML document contains Console.WriteLine(

{6}) -----------------
Series: {0}
Name: {1}
Author: {2}
Publisher: {3}
Volume: {4}
ISBN: {5}
 dr[Series] dr[Name] dr[Author] dr[Publisher] dr[Volume] dr[ISBN] listNum++); } } else if (choice == add) { //create a new DataRow object containing the table schema //from the DataSet DataRow newrow = ds.Tables[0].NewRow(); Console.WriteLine(
Enter the Series Name:); //Take the input from the user and store it into the DataRow newrow[Series] = Console.ReadLine(); Console.WriteLine(Enter the Manga's Name: ); newrow[Name] = Console.ReadLine(); Console.WriteLine(Enter the Author's Name: ); newrow[Author] = Console.ReadLine(); Console.WriteLine(Enter the Publisher's Name: ); newrow[Publisher] = Console.ReadLine(); Console.WriteLine(Enter the Volume Number: ); newrow[Volume] = Console.ReadLine(); Console.WriteLine(Enter the ISBN Number: ); newrow[ISBN] = Console.ReadLine(); //Add the updated DataRow into the DataSet ds.Tables[0].Rows.Add(newrow); Console.WriteLine(Updating Database file); //Open a FileStream to the Database in Write Mode FileStream fout = new FileStream(XML_Mangalist.xml FileMode.OpenOrCreate FileAccess.Write FileShare.ReadWrite); //Write the XML data to the stream ds.WriteXml(fout); //Close the Stream fout.Close(); Console.WriteLine(Database Updated!); } else if (choice == del) { //The number of the entry is the number defined by //the integer listNum. Console.WriteLine(Select number of entry to delete:
); } else if (choice == mod) { //The number of the entry is the number defined by //the integer listNum. Console.WriteLine(Select number of entry to modify:
); } else { Console.WriteLine(Please use one of the following commands
ls
add
del
mod
); } } catch(Exception e) { Console.WriteLine(e.Message); } } } } How can I make it so that it deletes the entry and modifies it and how can I arrange the titles alphabetically? Thanks again for your patience

kovan · Answer

let say you have the following in c:	est.xml This is the caption of the window to retrieve the text u use string getXML = getXMLNodeFromXMLFile(@c:	est.xml ApplicationSettings WindowCaption)) to set it u use setXMLNodeInXMLFile@c:	est.xml ApplicationSettings WindowCaption This is the new caption);

weapon_x33 · Answer

I tried a few things with the code but it doesn't seem to help or rather Im so bad I can't make anything of it...bah Im ashamed -_- Could you explain in a bit more detail how I am to use that code please? Thanks again

kovan · Answer

following functions might help EXAMPLE: string getXML = getXMLNodeFromXMLFile(GlobalStuff.SettingsFile SearchSettings Code)) public static string getXMLNodeFromXMLFile( string xmlFile string parentNode string node) { try { XmlDocument doc = new XmlDocument(); // get an XML document doc.Load(xmlFile); //load the file XmlNodeList xmlNode = doc.GetElementsByTagName(node); for(int i = 0; i < xmlNode.Count; i++) //loop through all the found nodes { if (xmlNode[i].ParentNode.Name == parentNode) //find the one we want in the collection { return xmlNode[i].InnerText.ToString(); //return the text } } return Node belonging to  + parentNode +  was not found in  + xmlFile; } catch(System.Exception e) //catch the exception such as if the file passed in is not found { return e.Message; } } EXAMPLE: myXML.setXMLNodeInXMLFile(GlobalStuff.SettingsFile SearchSettings Code ON); public static bool setXMLNodeInXMLFile( string xmlFile string parentNode string node string nodeValue) { try { XmlDocument doc = new XmlDocument(); // get an XML document doc.Load(xmlFile); //load the file XmlNodeList xmlNode = doc.GetElementsByTagName(node); for(int i = 0; i < xmlNode.Count; i++) //loop through all the found nodes { if (xmlNode[i].ParentNode.Name == parentNode) //find the one we want in the collection { xmlNode[i].InnerText = nodeValue; //set the text doc.Save(xmlFile); //save the file back return true; } } return false; } catch(System.Exception) //catch the exception such as if the file passed in is not found { return false; } }