根据地址名称通过百度地图API查询出坐标

百度地图ApiUrl

`string url = "http://api.map.baidu.com/geocoder?address={0}&output=json&key=这里用自己申请的key" `
```
//查询出门店列表
string sql = "select shopid, shopName,shopadress, lat ,lng as lon from Shop";
//单个门店的情况
if (shopid!=0)
{
sql += " where shopid=" + shopid;
}

    DataTable PlaceDt = kis_web.DBHelper.GetTable(sql);

    foreach (DataRow row in PlaceDt.Rows)

    {

      //请求

        var request = (HttpWebRequest)WebRequest.Create(string.Format(url, row["shopadress"]));

        var response = (HttpWebResponse)request.GetResponse();

        var responseString = new StreamReader(response.GetResponseStream()).ReadToEnd();

        //请求结果

        JObject jo = (JObject)JsonConvert.DeserializeObject(responseString);

        //有些地址是查询不出来result的,因此要做个判断

        if (string.Equals(jo["status"].ToString(), "OK") && jo["result"].ToString() != "[]")

        {

            string lat = jo["result"]["location"]["lat"].ToString();

            string lng = jo["result"]["location"]["lng"].ToString();

            //修改数据库中的门店坐标地址

            string updateSql = "UPDATE Shop SET lat = '{0}',lng = '{1}' WHERE shopid ='{2}'";

            int result = kis_web.DBHelper.ExeSQLs(string.Format(updateSql, lat, lng, row["shopid"]));

        }

    }

#测试DEMO可以直接赋值使用

    string url = "http://api.map.baidu.com/geocoder?address={0}&output=json&key=key";

    var request = (HttpWebRequest)WebRequest.Create(string.Format(url, "广州"));

    var response = (HttpWebResponse)request.GetResponse();

    var responseString = new StreamReader(response.GetResponseStream()).ReadToEnd();

    JObject jo = (JObject)JsonConvert.DeserializeObject(responseString);

    string lng = jo["result"]["location"]["lng"].ToString();

    string lat = jo["result"]["location"]["lat"].ToString();

    Response.Write(lng + "|" + lat);

---

*相关命名空间*

using Newtonsoft.Json;

using System.Net;

using Newtonsoft.Json.Linq;

*通过上诉的操作，这样就可以将数据库中拥有地址的门店赋值坐标*