filter xml data

Question

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?

Jaganathan Bantheswaran · Answer

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); } } } }

Sunny Sharma · Answer

Agree with Vulpes, mine is same.

Vulpes · Answer

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

Gurjeet Singh · Answer

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

Sunny Sharma · Answer

Hi michale, please show me XMlL (sample) structure and what you want to do.

filter xml data

Answers (5)