I am trying to read multiple XML files present in one directory (each XML have only one record) and display the records in DataGridView. I want if any of the XML file is updated with new data, its corresponding entry should be automatically updated/refreshed with new updated data in the DataGridView. After doing some search I found that I can use FileSystemWatcher to find if any file is changed, but can anyone please help how can I use it, I am unable to find a good example.
My XML files looks like (please note that there is no root node in it):
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<info>
<id>001</id>
<name>xyz</name>
<salary>1000</salary>
<phone>1234567890</phone>
</info>
My C# code to read XML and populate gridview is as follows:
using System.Xml;
using System.IO;
namespace XML_Reader
{
public partial class Form1 : Form
{
string[] fileArray;
string directory_path = "C:\\Users\\XYZ\\Desktop\\test\\";
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
//Add columns to empty datagridview
dataGridView1.Columns.Add("id", "id");
dataGridView1.Columns.Add("name", "name");
dataGridView1.Columns.Add("salary", "salary");
dataGridView1.Columns.Add("phone", "phone");
populateRecords();
}
private void populateRecords()
{
DataSet ds;
DataGridViewRow dg_row;
//Read all "Collection" files and records to datagrid
fileArray = Directory.GetFiles(directory_path, "Collection*.xml");
foreach (string xmlFile in fileArray_collection)
{
//Read the XML from the file
ds = new DataSet();
ds.ReadXml(xmlFile);
//create new row for datagrid
dg_row = (DataGridViewRow)dataGridView1.Rows[0].Clone();
//assign values to cells in the new row
dg_row.Cells[0].Value = ds.Tables["info"].Rows[0]["id"];
dg_row.Cells[1].Value = ds.Tables["info"].Rows[0]["name"];
dg_row.Cells[2].Value = ds.Tables["info"].Rows[0]["salary"];
dg_row.Cells[3].Value = ds.Tables["info"].Rows[0]["phone"];
//Add the new row to datagrid -- THE MOMENT RECORD IS DETECTED
dataGridView1.Rows.Add(dg_row);
dataGridView1.FirstDisplayedScrollingRowIndex = dataGridView1.Rows.Count - 1;//This will keep the last added row visible with vertical scrollbar being at bottom.
}
//Read the XML from the file
ds = new DataSet();
ds.ReadXml(xmlFile);
//create new row for datagrid
dg_row = (DataGridViewRow)dataGridView1.Rows[0].Clone();
//assign values to cells in the new row
dg_row.Cells[0].Value = "Series";
dg_row.Cells[1].Value = "-N/A-";
dg_row.Cells[2].Value = Convert.ToInt32(ds.Tables["archival-description"].Rows[0]["item-count"]); //Read Series count
dg_row.Cells[3].Value = "-N/A-";
dg_row.Cells[4].Value = DateTime.Now;
dg_row.Cells[5].Value = xmlFile;
//Add the new row to datagrid -- THE MOMENT RECORD IS DETECTED
dataGridView1.Rows.Add(dg_row);
dataGridView1.Refresh();
dataGridView1.FirstDisplayedScrollingRowIndex = dataGridView1.Rows.Count - 1;//This will keep the last added row visible with vertical scrollbar being at bottom.
}
}
}
}
No comments:
Post a Comment