Search code examples
asp.netxmldatasetgoogle-places-apixmldatasource

In ASP.net, How To Create a Dataset From an API Call That Returns XML but Select Specific Nodes

I am trying to make an API call to google places and google returns an XML document with multiple fields and lines of data. What is the best way to take that data, select specific nodes from it, and put it into a dataset?

Here is an example of my API call with control parameters passed into the API call:

("https://maps.googleapis.com/maps/api/place/search/xml?location=" _ & lat & "," & lng & "&radius=5000&keyword=" & Replace(searchvenuenametextbox, " ", "+") _ & "&sensor=false&key=" & googleapikey)

The best way to do this is preferred.

Solution

  • LINQ is the easiest way to do that. query the XML , just taking out the elements that you want then they can be easily inserted into DataTable