xml

Get location (Latitude & Longitude) for given address in c# using google api

May 13

In my application I wanted to find Latitude & Longitude of address of a person.

To do this I have used google api.

Bellow is c# code:

 public static List<string> GetLatLng(string address)
        {
            var requestUri = string.Format("http://maps.googleapis.com/maps/api/geocode/xml?address={0}&sensor=true", Uri.EscapeDataString(address));

            var request = WebRequest.Create(requestUri);
            var response = request.GetResponse();
            var xdoc = XDocument.Load(response.GetResponseStream());
            var latLngArray = new List<string>();
            var xElement = xdoc.Element("GeocodeResponse");
            if (xElement != null)
            {
                var result = xElement.Element("result");
                if (result != null)
                {
                    var element = result.Element("geometry");
                    if (element != null)
                    {
                        var locationElement = element.Element("location");
                        if (locationElement != null)
                        {
                            var xElement1 = locationElement.Element("lat");
                            if (xElement1 != null)
                            {
                                var lat = xElement1.Value;
                                latLngArray.Add(lat);

                            }
                            var element1 = locationElement.Element("lng");
                            if (element1 != null)
                            {
                                var lng = element1.Value;
                                latLngArray.Add(lng);
                            }
                        }
                    }
                }
            }
            return latLngArray;
        }

public static List<string> GetLatLng(string address)

{

var requestUri = string.Format("http://maps.googleapis.com/maps/api/geocode/xml?address={0}&sensor=true", Uri.EscapeDataString(address));

var request = WebRequest.Create(requestUri);

var response = request.GetResponse();

var xdoc = XDocument.Load(response.GetResponseStream());

var latLngArray = new List<string>();

var xElement = xdoc.Element("GeocodeResponse");

if (xElement != null)

{

var result = xElement.Element("result");

if (result != null)

{

var element = result.Element("geometry");

if (element != null)

{

var locationElement = element.Element("location");

if (locationElement != null)

{

var xElement1 = locationElement.Element("lat");

if (xElement1 != null)

{

var lat = xElement1.Value;

latLngArray.Add(lat);

}

var element1 = locationElement.Element("lng");

if (element1 != null)

{

var lng = element1.Value;

latLngArray.Add(lng);

}

return latLngArray;

}

Here What I did is just called google service & just extracted the latitude & longitude from the xml response which I got from service.

This free service has limitation of 2500 request per IP per day, so If your application is will request more than that then google api will block your IP temporarily & If you continue to do this then It may ban your IP also.

I your application will request more that 2500 request per day per IP then you may have to buy service from google.

How to read XML attributes using XPath in c#

Jun 25

In Previous tutorial I showed that how can we read xml node data using XPath
Now we will read attributes data from XML using XPath
Bellow is demo XML file from which we will read XML attribute data.

<?xml version="1.0" encoding="UTF-8"?>
<MyConfig>
<name firstname=”Vaibhav” lastname=”Shah”>V.S.</name>
<address>Mumbai</address>
</MyConfig>

<?xml version="1.0" encoding="UTF-8"?>

<address>Mumbai</address>

</MyConfig>

As shown in previous tutorial we need to load document, then read root node & then read node which we want to read.

// get the file path of input config document.
 string filePath = “Here comes path of your XML file”

_configXmlDoc = new XmlDocument();

// Load input configXml from the file.
 _configXmlDoc.Load(filePath);

var xpathQuery = "// MyConfig";

var configRootNode = _configXmlDoc.SelectSingleNode(xpathQuery);

//Extract name
xpathQuery = "./name";

 var selectSingleNode1 = configRootNode.SelectSingleNode(xpathQuery);
 if (selectSingleNode1 != null)
 var myName = selectSingleNode1.InnerText;

// get the file path of input config document.

string filePath = “Here comes path of your XML file”

_configXmlDoc = new XmlDocument();

// Load input configXml from the file.

_configXmlDoc.Load(filePath);

var xpathQuery = "// MyConfig";

var configRootNode = _configXmlDoc.SelectSingleNode(xpathQuery);

//Extract name

xpathQuery = "./name";

var selectSingleNode1 = configRootNode.SelectSingleNode(xpathQuery);

if (selectSingleNode1 != null)

var myName = selectSingleNode1.InnerText;

Now we will read attribute from node “name”

var firstName = selectSingleNode1.Attributes != null && (selectSingleNode1.Attributes.GetNamedItem("firstname") != null)
                ? selectSingleNode1.Attributes.GetNamedItem ("firstname").Value
                : string.Empty;

var firstName = selectSingleNode1.Attributes != null && (selectSingleNode1.Attributes.GetNamedItem("firstname") != null)

? selectSingleNode1.Attributes.GetNamedItem ("firstname").Value

: string.Empty;

In above code what we do is that we define condition that if node “name” has attribute & attribute “firstname” is not null then get the data from that attribute else pass empty string.
Like this we can read data for attribute “lastname” also.

var lastname =  selectSingleNode1.Attributes != null && (selectSingleNode1.Attributes.GetNamedItem("lastname") != null)
                ? selectSingleNode1.Attributes.GetNamedItem ("lastname").Value
                : string.Empty;

var lastname = selectSingleNode1.Attributes != null && (selectSingleNode1.Attributes.GetNamedItem("lastname") != null)

? selectSingleNode1.Attributes.GetNamedItem ("lastname").Value

: string.Empty;

How to read data from XML using XPath

Jun 25

Let’s say I want to read bello XML File using XPath

<?xml version="1.0" encoding="UTF-8"?>
<MyConfig>
<name>Vaibhav Shah</name>
<address>Mumbai</address>
</MyConfig>

<?xml version="1.0" encoding="UTF-8"?>

<name>Vaibhav Shah</name>

<address>Mumbai</address>

</MyConfig>

To read this XML first we need to load this document , which can be done as foolows

// get the file path of input config document.
 string filePath = “Here comes path of your XML file”

_configXmlDoc = new XmlDocument();

// Load input configXml from the file.
 _configXmlDoc.Load(filePath);

// get the file path of input config document.

string filePath = “Here comes path of your XML file”

_configXmlDoc = new XmlDocument();

// Load input configXml from the file.

_configXmlDoc.Load(filePath);

After loading the xml file we need to give root node name & after that we need to find nodes in that root node.
This can be done as follows

var xpathQuery = "// MyConfig";

var configRootNode = _configXmlDoc.SelectSingleNode(xpathQuery);

//Extract name
xpathQuery = "./name";
var selectSingleNode1 = configRootNode.SelectSingleNode(xpathQuery);
if (selectSingleNode1 != null)
var myName = selectSingleNode1.InnerText;

//Extract address
xpathQuery = "./EmailFrom";
var xmlNode1 = configRootNode.SelectSingleNode(xpathQuery);
if (xmlNode1 != null)
var myAddress = xmlNode1.InnerText;

var xpathQuery = "// MyConfig";

var configRootNode = _configXmlDoc.SelectSingleNode(xpathQuery);

//Extract name

xpathQuery = "./name";

var selectSingleNode1 = configRootNode.SelectSingleNode(xpathQuery);

if (selectSingleNode1 != null)

var myName = selectSingleNode1.InnerText;

//Extract address

xpathQuery = "./EmailFrom";

var xmlNode1 = configRootNode.SelectSingleNode(xpathQuery);

if (xmlNode1 != null)

var myAddress = xmlNode1.InnerText;

Like this we can read data from xml using XPath

How to Read xml file using Xpath in C#

Jan 11

Here i will show you how to read the xml file using Xpath in the C#

Here is the XML file which i have used…

    < ? xml version="1.0" encoding="UTF-8"?>
    < projects>
    < project id = "BP001">
    < name>Banking Project< /name>
    < / project>
    < project id = "TP001">
    < name>Telecommunication Project< /name>
    < / project>
    < project id = "PP001">
    < name>Portal Project< /name>
    < / project>
    < / projects>

< ? xml version="1.0" encoding="UTF-8"?>

< projects>

< project id = "BP001">

< name>Banking Project< /name>

< / project>

< project id = "TP001">

< name>Telecommunication Project< /name>

< / project>

< project id = "PP001">

< name>Portal Project< /name>

< / project>

< / projects>

(please remove the spaces from above XML File)

I have used simple Console Application Which reads this XML File & stores data in the list …

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml.XPath;
using System.Xml;

namespace ConsoleExamples
{
class readXMLusingXPath
{
static void Main(string[] args)
{
readxml read = new readxml();
read.xmlread();
}
}

class readxml
{
private XmlDocument ReadDoc = new XmlDocument();
string nodename = string.Empty;
static XmlNode node;
List strnodes = new List();
public void xmlread()
{
ReadDoc.Load("XMLFile1.xml");
node = ReadDoc.SelectSingleNode("projects");
loadnodes(node);
}
public void loadnodes(XmlNode nd)
{
XmlNodeList nodelist = nd.SelectNodes("project");
foreach (XmlNode node1 in nodelist)
{
if (node1.ToString() != null)
{
strnodes.Add(node1.Name.ToString() + " id = " + node1.Attributes.GetNamedItem("id").Value);
XmlNode node2 = node1.SelectSingleNode("name");
if (node2.ToString() != null)
{
strnodes.Add(node2.Name.ToString() + " = " + node1.SelectSingleNode("name").InnerText);
}
}
}
Console.Read();
}
}
}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Xml.XPath;

using System.Xml;

namespace ConsoleExamples

{

class readXMLusingXPath

{

static void Main(string[] args)

{

readxml read = new readxml();

read.xmlread();

}

class readxml

{

private XmlDocument ReadDoc = new XmlDocument();

string nodename = string.Empty;

static XmlNode node;

List strnodes = new List();

public void xmlread()

{

ReadDoc.Load("XMLFile1.xml");

node = ReadDoc.SelectSingleNode("projects");

loadnodes(node);

}

public void loadnodes(XmlNode nd)

{

XmlNodeList nodelist = nd.SelectNodes("project");

foreach (XmlNode node1 in nodelist)

{

if (node1.ToString() != null)

{

strnodes.Add(node1.Name.ToString() + " id = " + node1.Attributes.GetNamedItem("id").Value);

XmlNode node2 = node1.SelectSingleNode("name");

if (node2.ToString() != null)

{

strnodes.Add(node2.Name.ToString() + " = " + node1.SelectSingleNode("name").InnerText);

}

Console.Read();

}

Hope it helps ….

Export xml data into text file

Jan 04

If you want to export attributes from XML file to text file then you just have to read that attribute from xml & write it in text file…I have shown hoe to write string into text file Here ….

Here is full code….Here i have used other way to write string into text file ie. WriteAllText function…

private void button1_Click(object sender, EventArgs e)
 {

 string text = select();

 File.WriteAllText("file.txt", text);

 } 

public string select()
 {

 XmlDocument doc = new XmlDocument();

 string s = "";

 doc.Load("XMLFile1.xml");

 XmlNodeList nodes = doc.SelectNodes("/root/row");

 foreach (XmlNode node in nodes)

  {

  XmlAttributeCollection att = node.Attributes;

  foreach (XmlAttribute att1 in att)

   {

   s = s + att1.InnerText + System.Environment.NewLine;

   }

  }

 return s;

 }

private void button1_Click(object sender, EventArgs e)

{

string text = select();

File.WriteAllText("file.txt", text);

}

public string select()

{

XmlDocument doc = new XmlDocument();

string s = "";

doc.Load("XMLFile1.xml");

XmlNodeList nodes = doc.SelectNodes("/root/row");

foreach (XmlNode node in nodes)

{

XmlAttributeCollection att = node.Attributes;

foreach (XmlAttribute att1 in att)

{

s = s + att1.InnerText + System.Environment.NewLine;

}

return s;

}

Scroll to top

Vaibhav Shah's Blog

xml

Get location (Latitude & Longitude) for given address in c# using google api

How to read XML attributes using XPath in c#

How to read data from XML using XPath

How to Read xml file using Xpath in C#

Export xml data into text file

Recent Posts

Categories

xml

Recent Posts

Categories

Tags