IP2Location™ Olson Time Zone Database

public partial class olson_Timezone : System.Web.UI.Page
{
	string MyConnectionString = "datasource=localhost;port=3306;Database=;username=;password=";
	protected void Page_Load(object sender, EventArgs e)
	{
		MySqlConnection connection = new MySqlConnection(MyConnectionString);
		connection.Open();
		MySqlCommand SelectCommand = new MySqlCommand("select distinct country_code from ip2location_olson_timezone;", connection);
		MySqlDataAdapter adap = new MySqlDataAdapter(SelectCommand);
		DataTable dt = new DataTable();
		adap.Fill(dt);
		DropDownList3.DataSource = dt;
		DropDownList3.DataBind();
		DropDownList3.DataTextField = "country_code";
		DropDownList3.DataBind();
		select_RegionName();
	}

	public void select_RegionName()
	{
		MySqlConnection connection = new MySqlConnection(MyConnectionString);
		connection.Open();
		MySqlCommand SelectCommand2 = new MySqlCommand("select distinct region_name from ip2location_olson_timezone;", connection);
		MySqlDataAdapter adap2 = new MySqlDataAdapter(SelectCommand2);
		DataTable dt2 = new DataTable();
		adap2.Fill(dt2);
		DropDownList2.DataSource = dt2;
		DropDownList2.DataBind();
		DropDownList2.DataTextField = "region_name";
		DropDownList2.DataBind();
	}


	protected void check_Button(object sender, EventArgs e)
	{
	  if (Request.Form["DropDownList3"].ToString() == "")
		{
			myLabel.Text = "Country code is empty.";
		}
		else if (Request.Form["DropDownList2"].ToString() == "")
		{
			myLabel.Text = "Region name is empty.";
		}
		else if (city_name.Text == "")
		{
			myLabel.Text = "City name is empty.";
		}
		else {
			string selectedRegion = Request.Form["DropDownList2"].ToString();
			string selectedCountryCode = Request.Form["DropDownList3"].ToString();
			string cityName = city_name.Text;

			MySqlConnection connection = new MySqlConnection(MyConnectionString);
			connection.Open();
			string query = "Select olson_tz, abbreviation, dst_start, dst_end from ip2location_olson_timezone where country_code = '" + selectedCountryCode + "' AND region_name = @firstname AND city_name= @cityName";
			MySqlCommand SelectCommand2 = new MySqlCommand(query, connection);

			MySqlParameter param = new MySqlParameter();
			MySqlParameter param2 = new MySqlParameter();
			param.ParameterName = "@firstname";
			param.Value = selectedRegion;
			param2.ParameterName = "@cityName";
			param2.Value = cityName;
			SelectCommand2.Parameters.Add(param);
			SelectCommand2.Parameters.Add(param2);

			MySqlDataReader reader = SelectCommand2.ExecuteReader();

			if (reader.Read() == true)
			{
				myLabel.Text = "Country code: " + selectedCountryCode + "<br />Region name: " + selectedRegion + "<br />City Name: " + cityName + "<br />Olson Timezone: " + reader["olson_tz"].ToString() + "<br />Abbreviation: " + reader["abbreviation"].ToString() + "<br />DST Start: " + reader["dst_start"].ToString() + "<br />DST End: " + reader["dst_end"].ToString();
			}
			else
			{ myLabel.Text = "Data not found."; }
		}
	}
}

Imports System.Data.SqlClient
Imports System.Diagnostics.Eventing
Imports MySql.Data.MySqlClient

Public Class Form1

	Private Sub ddlCountryCode_SelectedIndexChanged(sender As Object, e As EventArgs) Handles MyBase.Load
		Dim connection As New MySqlConnection("Server=localhost;Database=;username=;password=")

		Dim sqlCommand As New MySqlCommand("select distinct country_code from ip2location_olson_timezone", connection)
		Dim adapter As New MySqlDataAdapter(sqlCommand)
		Dim table As New DataTable()

		adapter.Fill(table)
		ddlCountryCode.DataSource = table
		ddlCountryCode.DisplayMember = "country_code"
		ddlCountryCode.ValueMember = "country_code"
	End Sub


	Private Sub ddlRegionName_SelectedIndexChanged(sender As Object, e As EventArgs) Handles MyBase.Load
		Dim connection As New MySqlConnection("Server=localhost;Database=;username=;password=")

		Dim sqlCommand As New MySqlCommand("select distinct region_name from ip2location_olson_timezone", connection)
		Dim adapter As New MySqlDataAdapter(sqlCommand)
		Dim table As New DataTable()

		adapter.Fill(table)
		ddlRegionName.DataSource = table
		ddlRegionName.DisplayMember = "region_name"
		ddlRegionName.ValueMember = "country_code"
	End Sub

	Private Sub checkButton_Click(ByVal sender As Object, ByVal e As EventArgs) Handles checkButton.Click

		If (ddlCountryCode.Text = "") Then
			MessageBox.Show("Please choose the country code")

		ElseIf (ddlRegionName.Text = "") Then
			MessageBox.Show("Please choose the region name")
		ElseIf (TextBox1.Text = "") Then
			MessageBox.Show("Please fill in the city name")
		Else
			Dim selected_CountryCode = ddlCountryCode.Text
			Dim selected_RegionName = ddlRegionName.Text
			Dim city_name = TextBox1.Text

			Dim connection As New MySqlConnection("Server=localhost;Database=;username=;password=")

			Dim sql As String = "Select olson_tz, abbreviation, dst_start, dst_end from ip2location_olson_timezone where country_code ='" & selected_CountryCode & "' AND region_name = @regionName AND city_name = @cityName"
			Dim Command As New MySqlCommand(sql, connection)

			Command.Parameters.AddWithValue("@regionName", selected_RegionName)
			Command.Parameters.AddWithValue("@cityName", city_name)

			Dim adapter As New MySqlDataAdapter(Command)
			Dim table As New DataTable()
			adapter.Fill(table)

			If (table.Rows.Count = 0) Then
				MessageBox.Show("No data")
			Else
				Label4.Text = "Country code:" + selected_CountryCode + Environment.NewLine + "Region name: " + selected_RegionName + Environment.NewLine + "City name: " + city_name + Environment.NewLine + "Olson Timezone: " + table.Rows(0)(0).ToString() + Environment.NewLine + "Abbreviation: " + table.Rows(0)(1).ToString() + Environment.NewLine + "DST Start: " + table.Rows(0)(2).ToString() + Environment.NewLine + "DST End: " + table.Rows(0)(3).ToString()
			End If
		End If
	End Sub
End Class

package ip2locationjava;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

public class IP2LocationJava {

public static void main(String[] args) {

Scanner reader = new Scanner(System.in);
System.out.println("Enter your country code:");
String countryCode = reader.nextLine();
System.out.println("Enter your region name:");
String regionName = reader.nextLine();
System.out.println("Enter your city name:");
String cityName = reader.nextLine();

String databaseURL = "jdbc:mysql://localhost:3306/ip2location";
String user = "root";
String password = "";
Connection conn = null;
String data ="";

try {
	Class.forName("com.mysql.jdbc.Driver");
	conn = DriverManager.getConnection(databaseURL, user, password);

	PreparedStatement statement =conn.prepareStatement("select olson_tz, abbreviation, dst_start, dst_end from ip2location_olson_timezone where country_code='"+countryCode +"' AND region_name = ? AND city_name= ?");
	statement.setString(1, regionName);
	statement.setString(2, cityName);
	ResultSet rs = statement.executeQuery();

	if(rs.next() == true)
	{
		data = "Country code:"+ countryCode+"\nRegion name:"+regionName+"\nCity Name:"+cityName+"\nOlson Timezone " + rs.getString("olson_tz") + "\nAbbreviation " + rs.getString("abbreviation") +"\nDST Start " + rs.getString("dst_start") +"\nDST End " + rs.getString("dst_end");
		System.out.println(data);
	}else{
		   System.out.println("No data");
		}
} catch (ClassNotFoundException ex) {
		System.out.println("Could not find database driver class");
		ex.printStackTrace();
} catch (SQLException ex) {
		System.out.println("An error occurred.");
		ex.printStackTrace();
} finally {
	if (conn != null) {
		try {
			conn.close();
		} catch (SQLException ex) {
			ex.printStackTrace();
			}
	}
  }
}
}