1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56
|
while (reader.Read())
{ /*
********************************************
***** CONNEXION AU SITE INTERNET **********
********************************************
*/
// Create the web request
string chercher;
string conversion;
chercher = "http://local.yahooapis.com/MapsService/V1/geocode?appid=YD-9G7bey8_JXxQP6rxl.fBFGgCdNjoDMACQA--&street=";
conversion = Convert.ToString(reader["Address"]).Replace(' ', '+');
chercher += conversion;
chercher += "&city=";
chercher += (String)reader["City"];
chercher += "&zip=";
chercher += reader["CP"].ToString() + "\"";
request = WebRequest.Create(chercher) as HttpWebRequest;
response = request.GetResponse() as HttpWebResponse;
// Get the response stream
StreamReader Sreader = new StreamReader(response.GetResponseStream());
XmlDocument oDoc = new XmlDocument();
oDoc.LoadXml(Sreader.ReadToEnd());
XmlElement root = oDoc.DocumentElement;
XmlNode oNode = root.FirstChild;
sResult += String.Format(
"<PointOfInterest Name=\"{0}\" Address=\"{1}\" City=\"{2}\" Country=\"FR\" Phone=\"{3}\" Latitude=\"{4}\" Longitude=\"{5} />\r\n",
reader["PointOfInterest Name"],
reader["Address"],
reader["City"],
reader["Phone"],
oNode["Latitude"].InnerText,
oNode["Longitude"].InnerText,
);
}
}
response.Close();
sResult += "\r\n</PointOfInterestList>";
// fermeture du lecteur de base de données
reader.Close();
cmd.Dispose();
//Création du fichier xml et insertion des données
System.IO.File.WriteAllText(@"D:\monxml.xml", sResult);
} |
Partager