how to search xml data (textbox entered data to search xml file)

Question

Hi Friends i am new for using xml .so i have one requirement ie i want search wt i m entered in textbox that i check in xml and display matching data in to popup window. i am developing in windows app. i have xml file like 101 R-12 White 102 R-22 Green 103 R-32 White 104 R-134A Light Blue and i hve one textbox and button now i enter some text in to textbox and i click button then i search xml file like above data for example entered textbox like 10 and clivk search button i want to display matching with 10 like 100101102103.........etc only for start 10. please give me any idea how to search. Thanks Venkat.S

Vulpes · Answer

If you only want to search one column then change the query to: string[] results = (from element in doc.Element(DATAPACKET).Elements(ROWDATA).Elements( R_NAME ) where element.Value.StartsWith(search) select element.Value).ToArray();

Venkat S · Answer

Hi Vulpes  very very thanks for replay. but we have smal proble here that is i want to search only one column ie R_NAME so u have any idea . now also very fine . thanks alot Vulpes

Vulpes · Answer

Add this to your using directives; using System.Xml.Linq; Now try something like this in your button_Click handler: XDocument doc = XDocument.Load(venkat.xml); // or whatever thew file's called string search = textBox1.Text.Trim(); string[] results = (from element in doc.Element(DATAPACKET).Elements(ROWDATA).Elements() where element.Value.StartsWith(search) select element.Value).ToArray(); if (results.Length > 0) { string message = String.Join( results); MessageBox.Show(The following matches were found:

+ message); } else { MessageBox.Show(No matches were found); }