Multiple XML file data into datagridview

RAMIZ PA

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..

4 Replies

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

RAMIZ PA8y ago
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. Motta8y ago
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 PA8y ago
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. Motta8y ago
https://www.c-sharpcorner.com/UploadFile/mahesh/load-xml-file-into-a-datagridview-using-C-Sharp/