Hi,
I have a small problem, I have a xml file which contains some record, I want to search that record using Linq and if that record does not exists then It return null value.
The format of XML file is as follows.
<root>
<Employee>
<Name>John</Name>
</Employee>
<Employee>
<Name>Jack</Name>
</Employee>
<Employee>
<Name>Tori</Name>
</Employee>
</root>
How can I perform this task....
Help needed........
Thanks.
How to get perticular record in XML file using LINQ.
Ask by James Smith
Updated 03 Oct 2011
This code is work for me.
Use following link to solve your problem,
public class Employee
{
public string Name { get; set; }
}
at click of button event write following code.
XDocument data = XDocument.Load(HttpContext.Current.Server.MapPath("Team\\Team.xml"));
TeamDetails record = (from r in data.Elements("root").Elements("Team")
where r.Element("Id").Value.Equals(Request.QueryString["Id"].ToString())
select new TeamDetails()
{
Name = r.Element("Name").Value,
}).FirstOrDefault();
if (record != null)
{
//Display record.
}
This code might be useful for you.
Thanks.