ansaurus

Question

How to query this two XML files using C#?

Answer 1

A:

I personally don't like to work with DataView, DataTable and so on. I would created classes that correspond to your XML data. Eg. Contact and Numbers. Then I would read in the data using XDocument with XML LINQ syntax. You create a collection of contacts that you are going to set on the first GridView, and after clicking you just read the selected object from the collection and set the data on the second GridView.

No need for inner joins, everything is defined in classes and clearly better readable. Just an opinion.

EDIT:

More Infos:

Create classes that represent your data, e.g. Contact, Numbers

Read about XDocument at MSDN.

Example:

XDocument contactDoc = XDocument.Load(m_helpTopicFile);
var contacts = from xmlTopic in contactDoc.Descendants("Contact")
select new Contact
                     {
                         Id = int.Parse(xmlTopic.Element("ContactID").Value, CultureInfo.InvariantCulture),
                         Name = xmlTopic.Element("name").Value,

                     };

Then set this as the DataSource by using contacts.ToList()

testalino 2010-10-13 06:36:58

just a beginner...I have no idea about what you said..hehe

yonan2236 2010-10-13 06:39:20

I edited my answer, hope this helps

testalino 2010-10-13 07:08:15

Answer 2

+1 A:

Here is my solution(MainList is your 1st XML and DetailedList is the second.)

using System;
using System.Linq;
using System.Windows.Forms;
using System.Xml.Linq;

namespace WindowsFormsApplication1
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        private void button1_Click(object sender, EventArgs e)
        {
            OpenFileDialog OpenFD = new OpenFileDialog();
            OpenFD.InitialDirectory = Application.StartupPath;
            OpenFD.FileName = "";
            OpenFD.ShowDialog();
            if (OpenFD.FileName == "")
                return;
            textBox1.Text = OpenFD.FileName;
            ReadXMLFile(OpenFD.FileName);
        }
        private void ReadXMLFile(String strFileName)
        {
            var X = XDocument.Load(strFileName).Descendants("Contact").Select(N => new
        {
            ID = N.Element("ContactID").Value,
            Name=N.Element("Name").Value 
        });
        foreach (var XX in X)
        {
            dataGridView1.Rows.Add(XX.ID, XX.Name);
        }
    }


    private void dataGridView1_RowHeaderMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
    {
        String St = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
        var Data = XDocument.Load(Application.StartupPath + "\\DetailedList.xml").Descendants("Numbers")
                         .Where(X=>X.Element("ContactID").Value ==St)
                         .Select(N => new
                          {
                              Mobile = N.Element("Mobile").Value,
                              Office = N.Element("Office").Value,
                              Home = N.Element("Home").Value
                          });
        dataGridView2.Rows.Clear();
        foreach (var X in Data)
        {
            dataGridView2.Rows.Add(X.Mobile,X.Office,X.Home);
        }
    }
}
}

Output

Result

Add the necessary property to both the gridViews

I've created the columns at the design time.

And Instead of foreach we can wse LAMBDA Expression Hope you will understand.... Please let me know if you have any isses.

Enjoy!!!!!

Pramodh 2010-10-13 12:06:28

Wow! hehe, thank you very much sir for your answer :). I'm very glad someone has posted an answer, and it works. Though it's not that easy to understand, especially for just like me, beginner. But I will do more reading and play around with your code, all I want is to have an example in order for me to study it and serve as a basis in building a more advance application and coding, little by little. Thanks again :)

yonan2236 2010-10-13 14:17:42

I barely understand `LAMDA Expression`

yonan2236 2010-10-14 00:12:47

ansaurus

tags:

views:

answers:

How to query this two XML files using C#?

related questions