Fetch XML document in DataGridview ?

Question

Hi Guys Suppose I am having one small XML Document and I wanted to show contents of XML Document in Datagridview So How can I............? for example the XML document is :- 101 202 Jai Anurag and these EmpId and EmpName is wanted to shown in shown in dataGrid.

Nilanka Dharmadasa · Answer

Hi Ankit Finally I understood your requirement. Check this code. Please check 'DO YOU LIKE THIS ANSWER' checkbox if this helps you.

Nilanka Dharmadasa · Answer

Hi Ankit As this is a separate question would you mind post this in a separate thread? So it is easier to both of us. And also this requirement is not clear for me. You always have to read column 3 and 4 or it varies? With the answers for these questions can you post this in a separate thread?

Ankit Rathore · Answer

I am very beginner in C# so please don't mind even if I am asking a silly question...... Suppose I am having very Big xml document in which lots of child nodes available in between I have to choose only 3 or 4 so is it possible .........to do that ..........? I have to choose only 3 or 4 child node So how can I ........? Please Help me out ..........

Nilanka Dharmadasa · Answer

Hi Ankit Please do not forget to tick 'Do you like this answer' check box if this helps you. I have the solution for you. Check my code.

Ankit Rathore · Answer

Hi Niki now I am facing a problem in which I have more then two child node then the output is not coming Here the code is meant for two child node only .......... so please help me to give this below XML document .............. 101 202 Jai Anurag Bangalore Mumbai

Ankit Rathore · Answer

No its not like that I am just giving example  The more EMPLOYEE ID also may happen .............

Kirtan Patel · Answer

is this fix that Evry Employee Detail > will contain 2 ID Tags and Two Emp name tags ??

Ankit Rathore · Answer

HI I cant change the format

Kirtan Patel · Answer

Friend I can do what you want but you need to correctly as your XML should like below to retrieve the information efficiently your xml should be like in below format .. if you want code for below format then let me know i will help you :) will provide you very simpler code that you can understand :) 101 Jai 102 Anurag

Ankit Rathore · Answer

Hi Niki Thanks for the reply but I wanted to do in simple manner by using like DATASET then DATABIND then show it in DataGridView

Nilanka Dharmadasa · Answer

Hi friend Sorry. My previous answer is not in good foramt. So I uploaded the code. Check it. (Change the file path to your xml file path.) Please do not forget to check 'Do you like this answer' checkbox if it helps you.

Ankit Rathore · Answer

Hi please provide me another solutions.

Nilanka Dharmadasa · Answer

Hi friend I wrote a small application to read your xml file and display it in a datagridview. using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Xml; namespace WindowsFormsApplication3 { public partial class Form1 : Form { public Form1() { InitializeComponent(); dataGridView1.Columns.Add(col1 ID); dataGridView1.Columns.Add(col2 Name); } private void button1_Click(object sender EventArgs e) { XmlTextReader textReader = new XmlTextReader(C:\abc.xml);//Path of the xml file XmlDocument doc = new XmlDocument(); textReader.Read(); doc.Load(textReader); dataGridView1.Rows.Clear(); XmlNodeList employeeDetailNodes = doc.ChildNodes; foreach (XmlNode node in employeeDetailNodes) { XmlNodeList employeeIDs = node.ChildNodes; foreach (XmlNode idset in employeeIDs) { XmlNodeList ids = idset.ChildNodes; int j = 0; foreach (XmlNode id in ids) { int index; if (idset.Name.Equals(EmployeeID)) { index = dataGridView1.NewRowIndex; dataGridView1.Rows.Add(); if (dataGridView1.Rows[index] != null) { dataGridView1.Rows[index].Cells[0].Value = id.InnerText; } } else { index = j; if (dataGridView1.Rows[index] != null) { dataGridView1.Rows[index].Cells[1].Value = id.InnerText; } j++; } } } } } } } Run this and check. Please do not forget to check 'Do you like this answer' check box if this helps you.