Click here to Skip to main content
Click here to Skip to main content

Search XML Using LINQ in .NET

, 5 Sep 2012 CPOL
Rate this:
Please Sign up or sign in to vote.
How to search XML content using LINQ in .NET.

Introduction

This is my first post on CodeProject. I am expecting support and suggestions from all CodeProject friends.

Background 

I’m impressed with the features of Linear Query and its reliability. I am surprised solving a few problems that weren’t solved using other techniques but solved using LINQ. Before starting a detailed LINQ tutorial did you check my last post about LINQ? Well, no more talks, let’s start our the next tutorial is on how to search XML file content using LINQ.

In following few lines, I will teach you how to search content of an XML file using .NET. I got the solution to this problem after a day of practice. So let’s start now.   

Using the code

Consider a file named Search.xml with the following content:

<productlist title="ABC">
  <product title="ABC-Title">
    <doc id="Doc-abc" title="Abc document"/>
  </product>
 
  <product title="DEF">
    <doc id="Doc-DEF" title="Doc-DEF"/>
  </product>
 
  <product title="EFG">
    <doc id="EFG Document" description="Document of EFT"/>
  </product>
</productlist>

Great, now add a TextBox to take user input for search content. This code can search with product title and document title. Under the text change property or in any button control’s click event, add the following code. To run this code easily, make sure you have an empty XML file named SearchResult.xml, a DataGridView control named SrchList, and a BindingSource control named BS. This code will display all the matching results in the gridview.  

private void TxtSearchString_TextChanged(object sender, EventArgs e)
{
    StringBuilder st= new StringBuilder();
    XDocument doc = new XDocument(XDocument.Load("Search.xml"));
    var data = from item in doc.Descendants("doc")
               select new
               {
                   Ptitle=item.Parent.Attribute("title").Value,
                   title = item.Attribute("title").Value,
               };
    DataSet ds = new DataSet();
    StringBuilder sr = new StringBuilder();
    sr.Append("<product>");
    foreach (var p in data)
    {
        if (p.title.ToUpper().Contains(TxtSearchString.Text.ToUpper()) || 
                  p.Ptitle.ToUpper().Contains(TxtSearchString.Text.ToUpper()))
            sr.AppendLine("<doc Project-Title =\"" + 
               p.Ptitle.ToString() + "\" Document-Title=\"" + 
               p.title.ToString() + "\" />");
    }
    sr.Append("</product>");
    TextWriter w = new StreamWriter("searchResult.xml");
    w.Write(sr.ToString());
    w.Flush();
    w.Close();
    try
    {
        ds.ReadXml("searchResult.xml");
        if (ds.Tables.Count > 0)
        {
            BS.DataSource = ds.Tables[0];
            SrchList.DataSource = BS;
        }
    }
    catch (Exception ex)
    {
        throw;
    }
}

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

PrinceRimal
Software Developer
Nepal Nepal
Yauvaraj Rimal (Prince Rimal) is working in Software Development since early college days, from around 2007. He originally worked on Visual Basic and ASP. Later he worked on PHP, Now working on .Net Technology (Asp.Net, C# and VB.Net).
Follow on   Twitter   Google+

Comments and Discussions

 
GeneralMy vote of 2 Pinmemberstooboo5-Sep-12 15:13 
SuggestionMy 4 - respect compiler warnings: do dispose disposable objects, don't do catch-rethrow PinmemberAndreas Gieriet5-Sep-12 10:58 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web01 | 2.8.1411023.1 | Last Updated 5 Sep 2012
Article Copyright 2012 by PrinceRimal
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid