Domain Name And Internet Articles

Determine Web Visitors Country of Origin in the Drop Down List using ASP and MS-SQL Database

Determine Web Visitors Country of Origin in the Drop Down List using ASP and MS-SQL Database

Hexasoft Development Sdn. Bhd. (645996-K) 1-2-15 Mayang Mall Complex, Jalan Mayang Pasir 1, 11950 Bandar Bayan Baru, Penang, Malaysia. { sales@ip2location.com }

With the emergence of online technologies such as the Internet, people and businesses have increased their reliance and use of these mediums as an avenue for commerce as it can be more convenient. During the transaction online, there are times when it is important to preset the web visitor's country of origin, ZIP code, ISP and domain name at the drop down list to prevent fraud and to ease the complexity of registration task. This article shows you how by using ASP and MS-SQL Technology, it can be done.

Let us take a simple example of a user login from Canada and he needs to fill up a shopping cart. The form may be quite complex as some businesses need more information to prevent fraud. In this case, there are needs to preset certain info in the drop down list such as country of origin, ZIP code, ip and domain name of where the users login. As a result, the drop down list in this example will preset to Cananda, with the correct zip code and ip address.

In this tutorial, we use the IP2Location? IP-Country database to lookup country of origin from the visitor's IP address. The full version of IP-Country database is available for subscription at $49/year from http://ip2location.com. If you have the full version of IP2Location? IP-Country database, import process is easy done by using the Database Transformation Service (DTS) in MS-SQL.

Sample Codes in ASP and MS-SQL ------------------------------

"-" Then Response.Write "" & CountryLongName & ""& vbCrLf End If

' function to convert IP address to IP number Function Dot2LongIP (ByVal DottedIP) Dim i, pos Dim PrevPos, num If DottedIP = "" Then Dot2LongIP = 0 Else 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 Next End If End Function %> AFGHANISTAN ALBANIA ALGERIA AMERICAN SAMOA ANDORRA ANGOLA ANGUILLA ANTARCTICA ANTIGUA AND BARBUDA ARGENTINA ARMENIA ARUBA ASIA PACIFIC AUSTRALIA AUSTRIA AZERBAIJAN BAHAMAS BAHRAIN BANGLADESH BARBADOS BELARUS BELGIUM BELIZE BENIN BERMUDA BHUTAN BOLIVIA BOSNIA AND HERZEGOWINA BOTSWANA BOUVET ISLAND BRAZIL BRITISH INDIAN OCEAN TERRITORY BRUNEI DARUSSALAM BULGARIA BURKINA FASO BURUNDI CAMBODIA CAMEROON CANADA CAPE VERDE CAYMAN ISLANDS CENTRAL AFRICAN REPUBLIC CHAD CHILE CHINA CHRISTMAS ISLAND COCOS (KEELING) ISLANDS COLOMBIA COMOROS CONGO CONGO, THE DEMOCRATIC REPUBLIC OF THE COOK ISLANDS COSTA RICA COTE D'IVOIRE CROATIA CUBA CYPRUS CZECH REPUBLIC CZECHOSLOVAKIA (FORMER) DENMARK DJIBOUTI DOMINICA DOMINICAN REPUBLIC EAST TIMOR ECUADOR EGYPT EL SALVADOR EQUATORIAL GUINEA ERITREA ESTONIA ETHIOPIA EUROPEAN UNION FALKLAND ISLANDS (MALVINAS) FAROE ISLANDS FIJI FINLAND FRANCE FRANCE, METROPOLITAN FRENCH GUIANA FRENCH POLYNESIA FRENCH SOUTHERN TERRITORIES GABON GAMBIA GEORGIA GERMANY GHANA GIBRALTAR GREAT BRITAIN GREECE GREENLAND GRENADA GUADELOUPE GUAM GUATEMALA GUINEA GUINEA-BISSAU GUYANA HAITI HEARD ISLAND AND MCDONALD ISLANDS HOLY SEE (VATICAN CITY STATE) HONDURAS HONG KONG HUNGARY ICELAND INDIA INDONESIA IRAN, ISLAMIC REPUBLIC OF IRAQ IRELAND ISRAEL ITALY JAMAICA JAPAN JORDAN KAZAKSTAN KENYA KIRIBATI KOREA, DEMOCRATIC PEOPLE'S REPUBLIC OF KOREA, REPUBLIC OF KUWAIT KYRGYZSTAN LAO PEOPLE'S DEMOCRATIC REPUBLIC LATVIA LEBANON LESOTHO LIBERIA LIBYAN ARAB JAMAHIRIYA LIECHTENSTEIN LITHUANIA LUXEMBOURG MACAU MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF MADAGASCAR MALAWI MALAYSIA MALDIVES MALI MALTA MARSHALL ISLANDS MARTINIQUE MAURITANIA MAURITIUS MAYOTTE MEXICO MICRONESIA, FEDERATED STATES OF MOLDOVA, REPUBLIC OF MONACO MONGOLIA MONTSERRAT MOROCCO MOZAMBIQUE MYANMAR NAMIBIA NAURU NEPAL NETHERLANDS NETHERLANDS ANTILLES NEW CALEDONIA NEW ZEALAND NICARAGUA NIGER NIGERIA NIUE NORFOLK ISLAND NORTHERN MARIANA ISLANDS NORWAY OMAN PAKISTAN PALAU PALESTINIAN TERRITORY, OCCUPIED PANAMA PAPUA NEW GUINEA PARAGUAY PERU PHILIPPINES PITCAIRN POLAND PORTUGAL PUERTO RICO QATAR REUNION ROMANIA RUSSIAN FEDERATION RWANDA SAINT HELENA SAINT KITTS AND NEVIS SAINT LUCIA SAINT PIERRE AND MIQUELON SAINT VINCENT AND THE GRENADINES SAMOA SAN MARINO SAO TOME AND PRINCIPE SAUDI ARABIA SENEGAL SERBIA AND MONTENEGRO SEYCHELLES SIERRA LEONE SINGAPORE SLOVAKIA SLOVENIA SOLOMON ISLANDS SOMALIA SOUTH AFRICA SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS SPAIN SRI LANKA SUDAN SURINAME SVALBARD AND JAN MAYEN SWAZILAND SWEDEN SWITZERLAND SYRIAN ARAB REPUBLIC TAIWAN, PROVINCE OF CHINA TAJIKISTAN TANZANIA, UNITED REPUBLIC OF THAILAND TOGO TOKELAU TONGA TRINIDAD AND TOBAGO TUNISIA TURKEY TURKMENISTAN TURKS AND CAICOS ISLANDS TUVALU UGANDA UKRAINE UNITED ARAB EMIRATES UNITED KINGDOM UNITED STATES UNITED STATES MINOR OUTLYING ISLANDS URUGUAY UZBEKISTAN VANUATU VENEZUELA VIET NAM VIRGIN ISLANDS, BRITISH VIRGIN ISLANDS, U.S. WALLIS AND FUTUNA WESTERN SAHARA YEMEN ZAMBIA ZIMBABWE

IP2Location.com 1901 60th PL, L1020 Bradenton, FL 34203, United States. Tel: - +1 (866) 614-6288 Fax: - +1 (941) 240-2105 Website:http://www.ip2location.net

Other Article Sites

findabook.com  moneycd.info  a-mortgage.info   about-lemon-laws.info  aboutstudentloans.info
all-about-publishing.info  auctions-articles.info  bestcollege-university.com  bestispconnection.com
biblefolder.com  blogger-website.com  books-used.info  brokers-guide.info  buywindows.info  cable-dsl.info
career-miner.com  carpel-tunnel.info  cashinaflash.info  cashloanreviews.info  casinobell.com  chat-house.info
clearmycredit.info  collegeloantips.info  crones.info  depression-articles.info   dirnic.net  dishguides.info
divers-below.com  expodog.info   financewizz.com  fire-insurance.info  getgood.info  handleit.net   it-idea.info
health-supplies.info  hosting-right.com  insidealert.com  insurance-facts.info  jobs-employment.info
justgood.info  lookgold.net   lowcost-travel.info  money-source.info  myhostzone.info  numisblog.com
peoplesearchfinder.info  pr-articles.info  realeas.com   refinancing-guides.info  spyware-remove.info
telelot.info  the-law.info   toppaid.info  travel-deals.info  travelcorrect.com  wedding-guide-site.com
your-blog.info  your-credit.info

MORE ARTICLES:

Internet Domain Registration – Top 10 Most Frequently Asked Questions on Domain Name Registration
Here are the top ten most frequently asked questions regarding on Internet domain name registration:Q1. Which characters are allowed in Internet domain names?A: For normal ASCII domain names, the letters a-z, the numbers 0-9, and one special character, the hyphen or dash "-".

Using Expired Domain Software To Grab An Excellent Expired Domain Name
In practice, grabbing a good expired domain name is a cumbersome and difficult exercise. Grabbing an excellent expired domain name not only needs an extra effort but also a quick reflex and lightening action to beat the online competition. To make things easier and to quickly find expired domains, you will need to find a way or method that helps grow in the expired domain name business. In this regard, good and efficient expired domain software comes very practical and handy. A piece of expired domain software is also a useful tool that can provide you that extra edge to your business efforts.

Making Your Expired Domain an Enduring Income Creator - Creating the Magic of Expired Domain Gains
Your expired domains could be the treasure house of unlimited and continuous internet wealth that eventually may create amazing expired domain gains An expired domain is also a future and potential weapon capable of setting up an online money making machine

Free Duplicate Content and Expired Domain Names Tools Offered by Internet Marketing Leader Virante
Virante will continue to add a new free tool each week through the remainder of 2006.

Having a Domain Name And Web Site Gives Your Business The Key To The Door
Just like all things in life, the ways to run a business are rapidly changing and evolving. The potential involved with having a domain name/web site is staggering to say the least.

Turning Your Expired Domain Into a Profit Making Machine-Domain Parking Ideas
It is so common to see a registrar?s parking page cropping up in your browser window, when you type in a domain name to check what is on the site In fact, it could be a sheer wastage of what is possibly a good expired domain name

Internet Domain Registration - Establishing and Transferring Your Domain Name
If you're in business, one of the most important things to you may be your ability to establish an internet presence. Operating some type of functional web site for your business helps your customers find you, can present additional marketing opportunities through e-commerce, and offers advertising opportunities that you can not get elsewhere.

Nexx Cuts Price on .com Domain Names Web Host Offers Exceptional Value on Domain Names
Nexx Online Inc., an innovative North American web host and ICANN Accredited domain name registrar, today cut the price of their .com, .net, .org, .info and .biz domain names to only $7.95 per year.

Domains: Buying an Existing Domain Name Vs a New Domain Name
No one can deny that the Internet is here to stay and that businesses who do not embrace the internet are going to struggle in the coming years. With the Internet and Search Engines reaching a new level of maturity, I have noticed in their rankings that they are beginning to put more and more weight on the age of the domain in their index and because of this we have now reached a crossroad for many businesses to evaluate whether they are better off buying an existing domain versus registering a brand new domain. But Buyer Beware!

Domain Name Promotion And Web Site Design/SEO
If you do not have one million dollars in your pocket, you might find reading what I have to say worth a moment of your time.

Domain Names 101 - A Dummies Guide to Choosing Great Domain Names
When it comes to choosing your domain name, do not allow yourself to get stressed out or worry over choosing the perfect domain name that will make your website a success. When it comes down to it, there are several things you can do to ensure you choose the best type of domain for your business, and after that any number of domain names will work effectively for you.

The Wonderful World of Domain Flipping-Flipping Expired Domains to Your Advantage
Domain flipping is an exciting and a promising technique of making your expired domain a successful money earner, as well as a stable income generator There is lot to learn from domain flipping and its wonderful principles

Create Domain Names - Finding and Choosing Domain Names that Work
You've seen them.

General Pointers And Precautions Of Buying An Expired Web Domain
As every transaction that involves the transfer of an expired web domain is unique and special, it is quite difficult and strenuous to provide a list of advisories and precautions that can help novice expired domain name investors. Here are some common pointers and precautions that provide an air of safety and security while dealing with expired web domain.