XML DataBase - Small Windows Application

Seny

13y3kVisual Basic .NET

I am new in c# programming and i would like to create a small database in XML file for educational purpose.

The question is which way is proper or more editable when I create a small database in XML?

For example:

//////////Example 1////////////////

Nick Young

8th Street/

0123456789

//////////////////////////////////

//////////Example 2////////////////

XXXX

//////////////////////////////////

I would like to highlight here that i need to Add,Rename/Edit,Remove and Search students.

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
Accepted answer
Personally, I've always felt that child nodes are more flexible than attributes when storing data.

You might also like to read what W3Schools have to say on the matter:

http://www.w3schools.com/dtd/dtd_el_vs_attr.asp
0
Vulpes13y ago
I've changed the XML file so that each student's data is contained within an individual ... element:

Nick Young

8th Street/
0123456789

George Old

9th Street/
1234567890

Suppose now that you want to delete Nick Young from the file. The following LINQ to XML code will do it:

using System;
using System.Linq;
using System.Xml.Linq;

class Test
{
static void Main()
{
XElement students = XElement.Load("seny.xml");
string findName = "Nick Young";
XElement foundElement = (from student in students.Elements("student") where student.Element("name").Value == findName select student).FirstOrDefault();
if (foundElement != null)
{
foundElement.Remove(); // removes it from its parent
Console.WriteLine("{0} found and deleted", findName);
students.Save("seny2.xml");
}
else
{
Console.WriteLine("{0} not present in XML file", findName);
}

Console.ReadKey();
}
}

After running this code, the file should look like this:

George Old

9th Street/
1234567890

0
Seny13y ago
Thank you very much.I've created a small Application with the aid of a tutorial and i use the first example from above (Example 1), but i have a serious problem with [delete property].I don't know how can i delete a student using C#.

Here is the XML File examlpe:
////////////////////////////////////////////////

Nick Youngname>
8th Street/

0123456789
George Oldname>
9th Street/

1234567890

////////////////////////////////////////////////
0