forum

Home / DeveloperSection / Forums / how to fetch xml data in datagridview?

Ask Question

how to fetch xml data in datagridview?

Manoj Bhatt 2061 06-Jan-2016
I am importing data from an xml file to my datagridview in c# .The problem is that only one row is shown in data grid view .Please give me a suitable example to fetch all records from datagridview?
c# c#  .net  xml  xml reader 
Updated on 06-Jan-2016
Manoj Bhatt

Manoj Bhatt

Follow

Can you answer this question?

Answer

1 Answers

Anupam Mishra

Anupam Mishra

06-Jan-2016
Suppose your XML file contents are:

<?xml version="1.0" encoding="utf-8" ?>
<EMPLOYEES>
  <EMP>
    <EMPNO>001</EMPNO>
    <ENAME>Anupam Mishra</ENAME>
    <JOB>Software Developer</JOB>
    <MGR>0XX008</MGR>
    <HIREDATE>01-SEP-92</HIREDATE>
    <SAL>80000</SAL>
    </EMP>
    <EMP>
    <EMPNO>010</EMPNO>
    <ENAME>Vibhav Mahto</ENAME>
    <JOB>Sr. Software Developer</JOB>
    <MGR>0XX0001</MGR>
    <HIREDATE>01-JAN-90</HIREDATE>
    <SAL>8000</SAL>
    </EMP>
   </EMPLOYEES>
For displaying all rows to xml file.As you say, you are using datagridview.  The suitable code is shown below from fecthing data to any xml file :
   DataSet dataSet = new DataSet();
   dataSet.ReadXml(@"D:\Anupam Mishra\06.01.2016\UsingLinqEx\UsingLin\LinqEx.xml");
   dataGridView1.DataSource = dataSet.Tables[0];
You can also used a foreach or for loop of large iteration items for fetching values of any xml file.
Output of this program is follows:

answer 516630601105125






Liked By