Hi,
Here i will code you how to copy the data from XML file to DataSet or DataTable Using C# in .Net. XML File Should be in the below format as Shown below., here am calling ReadXML() function for binding XML Data into DataSet or DataTable.
C# Code
Here i will code you how to copy the data from XML file to DataSet or DataTable Using C# in .Net. XML File Should be in the below format as Shown below., here am calling ReadXML() function for binding XML Data into DataSet or DataTable.
C# Code
protected void Page_Load(object sender, EventArgs
e)
{
DataSet Ds = new DataSet();
Ds = ReadXML();
}
public DataSet
ReadXML()
{
string filePath = "D:\\Self
Practice\\Sol1\\Sol1\\Information.xml";
DataSet ds = new DataSet();
ds.ReadXml(filePath);
return ds;
}
XML FIle
<?xml version="1.0" encoding="utf-8" ?>
<TableNames>
<key id="001">
<value>Brinjal</value>
<price>100</price>
<location>India</location>
<season>spring</season>
</key>
<key id="002">
<value>Potato</value>
<price>150</price>
<location>USA</location>
<season>Summer</season>
</key>
<key id="003">
<value>tomato</value>
<price>50</price>
<location>UK</location>
<season>Fall</season>
</key>
<key id="004">
<value>carrot</value>
<price>20</price>
<location>France</location>
<season>spring</season>
</key>
<key id="005">
<value>Onion</value>
<price>300</price>
<location>japan</location>
<season>Holiday</season>
</key>
<key id="006">
<value>Beans</value>
<price>40</price>
<location>China</location>
<season>Fall</season>
</key>
<key id="007">
<value>Drum
Stick</value>
<price>10</price>
<location>london</location>
<season>Summer</season>
</key>
</TableNames>