获取IP所在地

 

    public string GetAddress(string ip)
    {
        DbCommon Db = new DbCommon();
        string[] ipArray;
        long numString;
        string address;
        ipArray = ip.Split('.');
        string df = ipArray[0].ToString();
        string dff = ipArray[1].ToString();

        numString = (long.Parse(ipArray[0]) * 256 * 256 * 256) + (int.Parse(ipArray[1]) * 256 * 256) + (int.Parse(ipArray[2]) * 256) + int.Parse(ipArray[3]) - 1;
        string selectStr = "Select   country,city   from   ip_address   where   ip1   <=   " + numString + "   and   ip2   >=   " + numString;
        SqlDataReader dr = Db.GetDataReader(selectStr);
        if (dr.Read())
            address = dr["country"].ToString() + dr["city"].ToString();
        else address = "****";
        return address;
    }