How can Read Data from XML file in C#?

Sandeep Singh Shekhawat

I have a class library project and in that project I have both xml file and class in which read data from that file.

So what code should write for it.

Thanks
Sandeep

6 Replies

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

Vulpes14y ago
You can store it anywhere that's convenient.

As the current directory may not be where you think it is, I'd use the full path to the file in the XElement.Load method rather than just config.xml if that's what you're doing at present.
0
Sandeep Singh Shekhawat14y ago
Hi Vulpes,

I am getting error when xml file load.

Could not find file 'C:\Program Files (x86)\Common Files\Microsoft Shared\DevServer\10.0\config.xml'.

So Where do I create this file ? Currently I have it in Root directory.

Thanks
Sandeep
0
Vulpes14y ago
It's also possible to read the file as if it were an ordinary XML file.

For example, using LINQ to XML:

using System;
using System.Linq;
using System.Xml.Linq;

class Test
{
static void Main()
{
XElement conn = XElement.Load("sandeep.xml");
string connString = (string)conn.Element("ConnectionString").Attribute("Name");
Console.WriteLine(connString);
Console.ReadKey();
}
}

/* output:

Data Source= sandeepss-PC; database= development; user=sa;password=knowdev

*/
0
Santhosh Kumar Jayaraman14y ago
Ideally do you want to read it from connection string of a config file?

then u can say
string str= ConfigurationManager.ConnectionStrings["con"].ToString();

and con is my connection string name

Check my article to know about more
http://www.c-sharpcorner.com/UploadFile/1a81c5/configuring-connection-string-in-app-config-file-during-runt/
0
Sandeep Singh Shekhawat14y ago
No, I don't want both way. I have an XML File like

And I want connection string in string variable from this. these are in class library.

0
Santhosh Kumar Jayaraman14y ago
if you want to convert xml to dataset

string path = "D:\\Santhosh\\XMLFile1.xml";
DataSet ds=new DataSet();
//Reading XML file and copying to dataset
ds.ReadXml(path);

If you want to convert xml to list of strings.
```
XDocument xDoc = XDocument.Load(new StringReader(xmlstr));
List modules = xDoc
    .Descendants("Module")
    .Select(n => n.Element("Name").Value)
    .ToList();

similarly you can modify it based on your custom class
```
0