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.