Unable to read from XML file

Anjan Kumar

Iam writing a code to read XML file and display it in DataGridView, but it doesn't work, my code is as follows...

give me suggestions

DataTable an = new DataTable();

XmlDocument xmldoc=new XmlDocument();
FileStream fsazm = new FileStream("D:\\data.xml", FileMode.Open, FileAccess.Read, FileShare.ReadWrite);
xmldoc.Load(fsazm);
XmlNodeList xmlnode = xmldoc.GetElementsByTagName("Student");
for (int i = 0; i < xmlnode.Count; i++)
{
XmlAttributeCollection xattrc = xmlnode[i].Attributes;
an.Rows[i][0] = xattrc[0].Value;
an.Rows[i][1] = xattrc[1].Value;
}

5 Replies

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

Vulpes12y ago
Accepted answer
You need to add some columns and rows to your DataTable:

DataTable an = new DataTable();
an.Columns.Add("Column1");
an.Columns.Add("Column2");
XmlDocument xmldoc=new XmlDocument();
FileStream fsazm = new FileStream("D:\\data.xml", FileMode.Open, FileAccess.Read, FileShare.ReadWrite);
xmldoc.Load(fsazm);
XmlNodeList xmlnode = xmldoc.GetElementsByTagName("Student");
for (int i = 0; i < xmlnode.Count; i++)
{
XmlAttributeCollection xattrc = xmlnode[i].Attributes;
DataRow row = an.NewRow();
row[0] = xattrc[0].Value;
row[1] = xattrc[1].Value;
an.Rows.Add(row);
}
dataGridView1.DataSource = an;
Anjan Kumar12y ago
Thank you for your response
Vulpes12y ago
The DataTable class has a WriteXml method which has a number of different overloads which are listed here:

http://msdn.microsoft.com/en-us/library/system.data.datatable.writexml(v=vs.110).aspx

Even if you only want to update the file, it's best just to recreate the whole thing from scratch which is what this method always does.
Anjan Kumar12y ago
will you please give me a hint on How to create / update XML file using the data in datatable
Lakshmanan Sethu Sankaranarayan12y ago
Hi Please refer the link http://www.c-sharpcorner.com/UploadFile/mahesh/load-xml-file-into-a-datagridview-using-C-Sharp/