Sponsored By
MindStick Cleaner
Advertise with Us
Advertisement
Advertise with Us
Follow Us
Follow _MindStick_ on Twitter View MindStick Software's LinkedIn profile View MindStick Software's Facebook profile
Mindstick
Article Article  Forum Forum  Blog Blog  Quiz Quiz  Beginner Beginner  Careers Careers  Contact Contact  Login Login  
Home | Product | Services | About Us | Interview | DeveloperSection | Submit an Article | Submit Blog
Report Abuse Form
Reason:    
   

Home >> .Net >> C# >> How to get perticular record in XML file using LINQ.
Author Post

James Smith


Total Post: 48
Member Since: 3/16/2011
Points: 270
How to get perticular record in XML file using LINQ.
Posted On: 8/12/2011 2:03:14 AM
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.
Author Post

Awadhendra Tiwari


Total Post: 126
Member Since: 1/19/2011
Points: 893
Re: How to get perticular record in XML file using LINQ.
Posted On: 8/12/2011 2:14:20 AM
Hi James,

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.
Author Post

Jenry Hock


Total Post: 18
Member Since: 9/7/2011
Points: 116
Re: How to get perticular record in XML file using LINQ.
Posted On: 10/3/2011 1:00:03 AM
Thanks Awadhenra,
This code is work for me.
Report Abuse Form
Reason:    
 
Total Online Users: 2888
Advertisement
MindStick DataConverter
Advertise with Us
  
Copyright © 2013MindStick. All Rights Reserved.