How Read File XML In CSharp?

Question

0.00/5 (No votes)

See more:

Hi for Exampel

<pre lang="xml"><?xml version="1.0" encoding="utf-8" ?>
- <ARI>
- <Unit ID="1" Name="آذربایجان شرقی">
  <city ID="1">آذرشهر</city>
  <city ID="2">اسکو</city>
  <city ID="3">اهر</city>
  <city ID="4">بستان‌آباد</city>
  <city ID="5">بناب</city>
  <city ID="6">تبریز</city>
  <city ID="7">جلفا</city>
  <city ID="8">چاراویماق</city>
</Unit>
- <Unit ID="2" Name="آذربایجان غربی">
  <city ID="1">ارومیه</city>
  <city ID="2">اشنویه</city>
  <city ID="3">بوکان</city>
  <city ID="4">پیرانشهر</city>
  <city ID="5">تکاب</city>
  <city ID="6">چالدران</city>
  <city ID="7">خوی</city>
  <city ID="8">خوی</city>
  <city ID="9">سردشت</city>
  <city ID="10">سلماس</city>
  <city ID="11">شاهین‌دژ</city>
  <city ID="12">ماکو</city>
  <city ID="13">مهاباد</city>
  <city ID="14">میاندوآب</city>
  <city ID="15">نقده</city>
  </Unit>

</ARI>

1-how read this file and show list city of unit with id 1 forexample?
2-how show name and id unit with id =1?

Posted 13-Jun-11 6:04am

javad_r_85

Add a Solution

Comments

Kim Togo 13-Jun-11 13:00pm

Is this for ASP.NET, Winform or WPF ?
Or are you only interesting in finding info in XML ?

4 solutions

Solution 4

Here are the options to consider:

Use System.Xml.XmlDocument class. It implements DOM interface; this way is the easiest and good enough if the size if the document is not too big.
See http://msdn.microsoft.com/en-us/library/system.xml.xmldocument.aspx[^].
Use the class System.Xml.XmlTextReader; this is the fastest way of reading, especially is you need to skip some data.
See http://msdn.microsoft.com/en-us/library/system.xml.xmlreader.aspx[^].
Use the class System.Xml.Linq.XDocument; this is the most adequate way similar to that of XmlDocument, supporting LINQ to XML Programming.
See http://msdn.microsoft.com/en-us/library/system.xml.xmldocument.aspx[^], http://msdn.microsoft.com/en-us/library/bb387063.aspx[^].

—SA

Posted 13-Jun-11 19:21pm

Sergey Alexandrovich Kryukov

Comments

Kim Togo 14-Jun-11 2:37am

Good options SA. My 5.

Sergey Alexandrovich Kryukov 14-Jun-11 3:01am

Thank you, Kim.
--SA

Solution 3

You can use XPath[^] querys and find info.

Select Nodes Using XPath[^] or Manipulate XML data with XPath and XmlDocument (C#)[^]

Posted 13-Jun-11 6:55am

Kim Togo

Solution 2

DataSet ds = new DataSet();
ds.ReadXml (MapPath("books.xml"));
DataGrid1.DataSource = ds;
DataGrid1.DataBind();

Or have alook in the following link,-

http://www.stardeveloper.com/articles/display.html?article=2009030701&page=1[^]

http://www.w3schools.com/aspnet/aspnet_repeater.asp[^]

Posted 13-Jun-11 6:35am

Prasanta_Prince

Comments

Kim Togo 13-Jun-11 12:59pm

But this example has nothing to do with selecting/searching nodes/elements in XML. And where do ASP.NET get from?
OP has never mention anything for on ASP.NET. My vote of 1.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kim Togo · Accepted Answer · 2011-06-13T06:12:00

Solution 1

If you are not restricted to C# < 3.5. I would use LINQ to XML[^] to that type of query. Very easy to use.

C#

XElement xml = XElement.Load(@"c:\xml\data.xml");
var result = from units in xml.Element("ARI").Elements("Unit")
             from city in units.Elements("city")
             where city.Attribute("ID").Value == "1"
             select city;

Posted 13-Jun-11 6:12am

Kim Togo

Comments

NandaKumer 13-Jun-11 12:18pm

nice one.

Kim Togo 13-Jun-11 12:57pm

Thanks Nanda

yesotaso 13-Jun-11 13:45pm

Indeed easist way and cleanest way if the restriction does not apply... My 5.

Kim Togo 14-Jun-11 2:36am

Thanks

RakeshMeena 14-Jun-11 1:31am

Nice one.

Kim Togo 14-Jun-11 2:36am

Thanks

parmar_punit 14-Jun-11 1:40am

good one, my 5

Kim Togo 14-Jun-11 2:36am

Thanks

Sergey Alexandrovich Kryukov 14-Jun-11 3:00am

My 5.
Down-voter's attacks couple of days....
--SA

Kim Togo 14-Jun-11 3:05am

Thanks SA. And yes, vote 1 would be best if there also was a comment on why.