First create an xml file as below and name it as Countries.xml
<?xml version="1.0" encoding="utf-8" ?>
<Countries>
<Country Id ="1">
India
</Country>
<Country Id ="2">
U.S.A
</Country>
<Country Id ="3">
China
</Country>
<Country Id ="4">
U.K
</Country>
</Countries>
<Countries>
<Country Id ="1">
India
</Country>
<Country Id ="2">
U.S.A
</Country>
<Country Id ="3">
China
</Country>
<Country Id ="4">
U.K
</Country>
</Countries>
Then write the code as below to query xml
using System;
using System.Linq;
using System.Xml.Linq;
public partial class Linq_QueryXMLUsingLINQ : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
XElement xEle = XElement.Load(@"D:\Countries.xml");
var list = from l in xEle.Elements("Country")
where ((string)l.Element("Name")).Trim() == "India"
select l.Element("Name");
foreach (var item in list)
{
Response.Write(item);
}
}
}
using System.Linq;
using System.Xml.Linq;
public partial class Linq_QueryXMLUsingLINQ : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
XElement xEle = XElement.Load(@"D:\Countries.xml");
var list = from l in xEle.Elements("Country")
where ((string)l.Element("Name")).Trim() == "India"
select l.Element("Name");
foreach (var item in list)
{
Response.Write(item);
}
}
}