Any way to populate elements from xml in Datagridview using C #

Question

I am working on a datagridview. In which I have to show the column values ​​from xml to the grid view column. I have xml: In addition, I have a grid view that has two columns "ID" and "NAME", I want to fill in the values ​​from the xml view into the grid. Can anyone help?

<employee> <empdetails id="1" name="sam"/> <empdetails id="2" name="robin"/> <empdetails id="3" name="victor"/> </employee> 

Answer 1

You can read the xml in the DataSet and pass the empdetails DataSet to the DataGridView as follows:

 //Create xml reader XmlReader xmlFile = XmlReader.Create("fullPathToYourXmlFile.xml", new XmlReaderSettings()); DataSet dataSet = new DataSet(); //Read xml to dataset dataSet.ReadXml(xmlFile); //Pass empdetails table to datagridview datasource dataGridView.DataSource = dataSet.Tables["empdetails"]; //Close xml reader xmlFile.Close(); 

Answer 2

You can use XML Linq as below

 XElement xml = XElement.Load(XMl String); var xmlData = from item in xml.Element("empdetails") select new {id = item.Attribute("id") , name= item.Attribute("name")}; dataGrid.DataSource = xmlData.ToList(); 

Answer 3

 C# DataSet ds = new DataSet(); ds.ReadXml("C:/XMLData/employee.xml"); DataGridView1.DataSource = ds.Tables(0); VB.NET Dim ds As New DataSet ds.ReadXml("C:/XMLData/employee.xml") DataGridView1.DataSource = ds.Tables(0)