how to get matching value in xml file and display in textbox

Venkat S

15y4.8k.NET

Hi friends,

i have xml file like

101
30
34
6.12
3.64

101
28
33
6.02
3.90

101
26
32
5.63
4.05

101
24
31
5.25
4.82

101
22
30
4.26
5.05
......................
and then i have Two TextBoxes and One Button
i am enter a value in text box1 then i click button it ll go and get the matching value and display textbox2.

for example in above xml file i enter txtbox1(30) and i click button I want to dispaly textbox2(6.12)
txtbox(28) ....txtbox2(6.02)....like that

please give me any idea how to match and get it.

Thanks
Venkat.S

4 Replies

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

Pradeep Chandraker15y ago
Sorry about that, I thought it is string.

XDocument.Parse is used when you have xml string.

XDocument.Load is used when you have xml file.

Anyway thats great you found solution.
Venkat S15y ago
Hi Pradeep Chandraker,

i got the solution
the above code just change into parse to load.

XDocument oXDoc = XDocument.Load(path + @"\Refrigirater.xml");

var val = from p in oXDoc.Element("DATAPACKET").Elements("data1") where p.Element("R_PRE").Value == textBox2.Text select p.Element("R_TEMP").Value;

textBox3.Text = val.First().ToString();

thanks for give idea.
Venkat S15y ago
Hi Pradeep Chandraker

thanks for replay,

here we have small problem all data in my xml file then how to call them ...
but i try to give the path get an error.
Xml Exception
Data at the root level is invalid. Line 1, position 1.
Pradeep Chandraker15y ago
Try this, it should solve your problem.

I made one change in your xml string, I added root element "".

string strXML = ""
+"101 "
+"30 "
+"34 "
+"6.12"
+"3.64 "
+" "
+" "
+"101"
+"28"
+"33"
+"6.02 "
+"3.90"
+" "
+"101"
+"26 "
+"32 "
+"5.63"
+"4.05"
+" "
+" "
+"101 "
+"24 "
+"31 "
+"5.25"
+"4.82 "
+" "
+""
+"101 "
+"22"
+" 30"
+" 4.26"
+ "5.05"
+ "";

XDocument oXDoc = XDocument.Parse(strXML);

var val = from p in oXDoc.Element("data").Elements("data1")
where p.Element("R_PRE").Value == txtbox1.Text
select p.Element("R_TEMP").Value;

txtbox2.Text = val.First().ToString();