Click here to Skip to main content
12,953,014 members (55,580 online)
Click here to Skip to main content
Add your own
alternative version


165 bookmarked
Posted 4 Aug 2008

How to convert IP address to country name

, 14 Aug 2008 CPOL
Rate this:
Please Sign up or sign in to vote.
How do I retrieve the country name and country code from an IP number?

How to retrieve a visitor's IP address

Every visitor to your site or web application has an IP address. It is quite handy to be able to get that address. It can be used for security logging, or perhaps tracing. It can also be used to determine where they are in the world, or at least where their ISP is.

The difficulty is when they are behind a proxy of some sort, and you can only see the IP address of the proxy server. So, here are the code snippets in ASP.NET that first check for an IP addresses that's forwarded from behind a proxy, and if there's none, then just gets the IP address. Here's the same IP retriever with proxy detection in .NET, but in VB.NET:

Dim nowip As String 
nowip = Request.ServerVariables("HTTP_X_FORWARDED_FOR") 
If nowip = "" Then
   nowip = Request.ServerVariables("REMOTE_ADDR")
End If

How do I convert an IP address to an IP number?

IP address (IPV4) is divided into four sub-blocks. Each sub-block has a different weight number, each powered by 256. The IP number is being used in the database because it is efficient to search between a range of numbers in the database.

The beginning IP number and the ending IP number are calculated based on the following formula:

IP Number = 16777216*w + 65536*x + 256*y + z (1)


IP Address = w.x.y.z

For example, if the IP address is "", then its IP number is "3401190660" based on the above formula.

IP Address =
So, w = 202, x = 186, y = 13 and z = 4

IP Number = 16777216*202 + 65536*186 + 256*13 + 4
          = 3388997632 + 12189696 + 3328 + 4
          = 3401190660

To reverse the IP number to the IP address:

w = int ( IP Number / 16777216 ) % 256
x = int ( IP Number / 65536 ) % 256
y = int ( IP Number / 256 ) % 256
z = int ( IP Number ) % 256

where, % is the mod operator and int returns the integer part of the division.

How do I retrieve the country name and the country code from the IP number?

Search the IP-country database to match a unique record that has the IP number that fits between the beginning IP number and the ending IP number.

For example, the IP address "" is equivalent to the IP number "3401190660". It belongs to the following record in the database because it is between the beginning and the the ending of the IP number:


From the recordset, the country name is Malaysia and the country code is MY. Here is a useful link.

How do I use this database

CSV file format

The CSV file contains four fields:

  • Beginning of the IP address range
  • Ending of the IP address range
  • Two-character country code based on ISO 3166
  • Three-character country code based on ISO 3166
  • Country name based on ISO 3166
"0033996344","0033996351","GB","GBR","UNITED KINGDOM"
"0050331648","0083886079","US","USA","UNITED STATES"
FieldData TypeField Description
IP_FROMNUMERICAL (DOUBLE)Beginning of the IP address range.
IP_TONUMERICAL (DOUBLE)Ending of the IP address range.
COUNTRY_CODE2CHAR(2)Two-character country code based on ISO 3166.
COUNTRY_CODE3CHAR(3)Three-character country code based on ISO 3166.
COUNTRY_NAMEVARCHAR(50)Country name based on ISO 3166

Download CSV database

Convert to Access database

Here is the code-behind:

Partial Class How_to_Convert_IP_Address_Country _
        Inherits System.Web.UI.Page

    Protected Sub Page_Load(ByVal sender As Object,_
        ByVal e As System.EventArgs) Handles Me.Load
        Dim nowip As String
        nowip = Request.ServerVariables("HTTP_X_FORWARDED_FOR")
        If nowip = "" Then
            nowip = Request.ServerVariables("REMOTE_ADDR")
        End If

        If txtIPAddress.Text = "" Then
            txtIPAddress.Text = nowip
        End If
        lblError.Text = ""
    End Sub

    Protected Sub Button1_Click(ByVal sender As Object,_
        ByVal e As System.EventArgs) Handles Button1.Click
        On Error GoTo HandleError

        Dim dottedip As String
        Dim Dot2LongIP As Double
        Dim PrevPos As Double
        Dim pos As Double
        Dim num As Double

        dottedip = txtIPAddress.Text

            For i = 1 To 4
                pos = InStr(PrevPos + 1, dottedip, ".", 1)
                If i = 4 Then
                    pos = Len(dottedip) + 1
                End If
                num = Int(Mid(dottedip, PrevPos + 1, pos - PrevPos - 1))
                PrevPos = pos
                Dot2LongIP = ((num Mod 256) * (256 ^ (4 - i))) + Dot2LongIP

        txtIPNumber.Text = Dot2LongIP

        lblError.Text = Err.Description
    End Sub
End Class

Here is the output:



This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Web Developer
United States United States
No Biography provided

You may also be interested in...

Comments and Discussions

BugDownload links not working properly Pin
Member 124999823-May-16 2:26
memberMember 124999823-May-16 2:26 
GeneralMy vote of 3 Pin
jjjjjjbbbbbb3-Oct-14 22:47
professionaljjjjjjbbbbbb3-Oct-14 22:47 
QuestionTHANKS! Pin
tedkrapf1-Jul-13 11:47
membertedkrapf1-Jul-13 11:47 
GeneralMy vote of 5 Pin
Kunal_Chowdhury21-Apr-11 2:32
mvpKunal_Chowdhury21-Apr-11 2:32 
Generala copy of.......... Pin
Аslam Iqbal25-Mar-11 9:52
memberАslam Iqbal25-Mar-11 9:52 
GeneralMy vote of 3 Pin
nvijin27-Nov-10 23:26
membernvijin27-Nov-10 23:26 
GeneralMy vote of 1 Pin
Toddonian15-Dec-09 7:44
memberToddonian15-Dec-09 7:44 
GeneralWork perfectly in C#, Thank you!! Pin
mehran_o_net19-Sep-09 9:03
membermehran_o_net19-Sep-09 9:03 
GeneralVB.Net Intergate Pin
Martin Houstrup17-Aug-09 5:22
memberMartin Houstrup17-Aug-09 5:22 
Questiondoubt with the above Pin
svknair20-Jan-09 1:04
membersvknair20-Jan-09 1:04 
AnswerRe: doubt with the above Pin
davidberlin10-Mar-09 3:43
memberdavidberlin10-Mar-09 3:43 
GeneralThe world changes and Internet even faster. Pin
zeek22-Dec-08 8:08
memberzeek22-Dec-08 8:08 
Have read your article, and indeed very nicely done.
I have tried this as well some time ago, but the problem I stumbled on is the fact that the Internet (and the IP allocations) is/are fluid. The database idea is great for fast access and quick results, although I have found that in my case, the data it is already outdated and no longer correct or incomplete within as little as 24 hours, and just gets worse over time.

A realtime link to the source, besides a stand alone static one is needed for accuracy, like a link to the controllers of IP assignments. (and it's fellow controllers) or better yet access to IANA.

Someone should start a realtime online link service into these databases for the good of all Internet users. There seem to be a few "free" providers, (never used them), but word on the street is that the quality varies = not accurate, incorrect, outdated or not maintained.

At present I do a lazy screen scrape off each of the Internet registries as applicable and deal with it later. Not exactly a clean or healthy way, but my data for that request at that time was really correct. (and now for the city name and street name......) Big Grin | :-D

If anyone has ideas on how to keep the DB current, please share.

Thanks all

Jay S
QuestionWhich Country is this Pin
khemant041115-Dec-08 20:51
memberkhemant041115-Dec-08 20:51 
QuestionDatabase for Ip address Pin
desigank12-Nov-08 20:24
memberdesigank12-Nov-08 20:24 
Generalnot simple. Use shifts or.. Pin
ykorotia17-Oct-08 7:42
memberykorotia17-Oct-08 7:42 
GeneralMe da este error. Pin
Member 173994428-Aug-08 7:32
memberMember 173994428-Aug-08 7:32 
GeneralVery useful Pin
jsreekumar22-Aug-08 12:07
memberjsreekumar22-Aug-08 12:07 
GeneralCool Pin
ashu fouzdar19-Aug-08 3:23
memberashu fouzdar19-Aug-08 3:23 
GeneralWow! Pin
AbhilashAshok13-Aug-08 20:12
memberAbhilashAshok13-Aug-08 20:12 
GeneralVery nice Pin
Petros Amiridis11-Aug-08 23:00
memberPetros Amiridis11-Aug-08 23:00 
Generalthanks Pin
Member 404680211-Aug-08 22:47
memberMember 404680211-Aug-08 22:47 
QuestionCity codes too? Pin
Wayne Hetherington11-Aug-08 13:01
memberWayne Hetherington11-Aug-08 13:01 
GeneralInteresting Pin
kornakar5-Aug-08 20:38
memberkornakar5-Aug-08 20:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

Permalink | Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.170525.1 | Last Updated 14 Aug 2008
Article Copyright 2008 by aspxCode
Everything else Copyright © CodeProject, 1999-2017
Layout: fixed | fluid