filter xml data

Gurjeet Singh

Hi,

I have thousand of records in Xml file. I want to filter data just like as sql server "Like" operator. Is it possible on Xml File or not?

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jaganathan Bantheswaran13y ago
Try this,

using System.IO;
using System;
using System.Xml;
using System.Xml.XPath;
using System.Collections;

class Program
{
    static void Main()
    {
       string xml = @"

    MichaelSmith
    Smthfs


    John
    Macsmith
    ";

using (StringReader stream = new StringReader(xml))

{

XPathDocument doc = new XPathDocument(stream);
XPathNavigator nav = doc.CreateNavigator();

// Compile a standard XPath expression
XPathExpression expr;
//If your Env is XPath 2.0 then use lower-case() instead of translate
expr = nav.Compile("/root/customer/lastname[contains(translate(text(),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'), 'SMITH')] | /root/customer/firstname[contains(translate(text(),'abcdefghijklmnopqrstuvwxyz','ABCDEFGHIJKLMNOPQRSTUVWXYZ'), 'SMITH')] ");
XPathNodeIterator iterator = nav.Select(expr);

try
{
while (iterator.MoveNext())
{
     XPathNavigator nav2 = iterator.Current.Clone();
     Console.WriteLine("Found: " + nav2.Value);
}
}
catch(Exception ex)
{
   Console.WriteLine(ex.Message);
}

}
    }


}
0
Sunny Sharma13y ago
Agree with Vulpes, mine is same.
0
Vulpes13y ago
Here's some basic code to filter the XML file using LINQ to XML:

using System;
using System.Linq;
using System.Xml.Linq;

class Program
{
static void Main()
{
XElement customers = XElement.Load("michale.xml");
string filter = "smi";
string[] matches = (from xe in customers.Elements("customer").Elements("lastname") where xe.Value.ToLower().Contains(filter.ToLower()) select xe.Value).ToArray();
foreach(string match in matches) Console.WriteLine(match);
Console.ReadKey();
}
}

I've added a root node to the file which now looks like this:

Michael
Smith

John
Macsmith

As expected, the output of the program is:

Smith
Macsmith
0
Gurjeet Singh13y ago

Michael
Smith

John
Macsmith

in textbox, if i type only "smi" and click on button. both smith and Macsmith display on Grid view

0
Sunny Sharma13y ago
Hi michale,

please show me XMlL (sample) structure and what you want to do.
0