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

Venkat S

15y24.9k.NET

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 100,101,102,103.........etc only for start 10.

please give me any idea how to search.

Thanks
Venkat.S

3 Replies

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

Vulpes15y ago
Accepted 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 S15y ago
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
Vulpes15y ago
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:\r\n\n" + message);
}
else
{
MessageBox.Show("No matches were found");
}