Multiple XML file data into datagridview

Question

Dear friends, Can someone help me with writing a windows form program to read all xml files (file names are in different name for ex. 123.xml,kjl.xml,563.xml etc etc) within a directory and fetch all data from xml and populate into a datagrid view. Please help.. Thanks..

RAMIZ PA · Answer

Dear Jeff, Thanks for your reply, But something issue. Im using same format xml fies only. Can you correct this code? using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; namespace XML_LOADER { public partial class Form1 : Form { public Form1() { InitializeComponent(); } private void Form1_Load(object sender, EventArgs e) { var dataSet = new DataSet(); foreach (var file in ("c:\*.xml")) { dataSet.ReadXml(file); } } private void button1_Click(object sender, EventArgs e) { var dataSet = new DataSet(); foreach (var file in ("c:\*.xml")) { dataSet.ReadXml(file); } dataGridView1.DataSource = dataSet.Tables[0]; } } }

Jefferson S. Motta · Answer

try: var dataSet = new DataSet(); foreach(var file in directory) (sample) { dataSet.ReadXml(file); } I did this with SqlConnection, I never use to xml, but I guess that dataSet 'll get all data, but the xml must be the same structure.

RAMIZ PA · Answer

HI Jeff, Thanks for your reply, But this will read only one file at a time and I need to read all xml files in a particular directory and shown in to the datagrid. Is it possible ? Please help.

Jefferson S. Motta · Answer

https://www.c-sharpcorner.com/UploadFile/mahesh/load-xml-file-into-a-datagridview-using-C-Sharp/