XML as Database
-
Hello all, i have a windows application which needs a small database (each record has 7 items) and i am thinking as using xml as database. I will need to add, delete, update the records (and show them ofcourse in a datagrid). Is there any documentation (article or sample code) to look at? Thanks a lot Knowledge is a power.
-
Hello all, i have a windows application which needs a small database (each record has 7 items) and i am thinking as using xml as database. I will need to add, delete, update the records (and show them ofcourse in a datagrid). Is there any documentation (article or sample code) to look at? Thanks a lot Knowledge is a power.
Using xml as database in the simplest sense is basically storing data as text file in xml format (that is, unless you're using SQL Server 2005 to store your xml). What you need to learn is XPath, and more specifically XQuery. These are comparable to understanding SQL syntax to manipulate database. The XmlDocument class provides you several functions to load and save text files, and to manipulate xml nodes within. I believe the ToDoList[^] application in CodeProject uses Xml to store data, if you want to look at a sample project. Hope that helps :) Edbert Sydney, Australia "A day without sunshine is like, you know, night." -- modified at 0:39 Tuesday 7th February, 2006
-
Hello all, i have a windows application which needs a small database (each record has 7 items) and i am thinking as using xml as database. I will need to add, delete, update the records (and show them ofcourse in a datagrid). Is there any documentation (article or sample code) to look at? Thanks a lot Knowledge is a power.
Marc Clifton's XmlDb is a good example. http://www.codeproject.com/dotnet/XmlDb.asp