Step 1: Download IP2Location LITE database, unzip the file follow the instruction in order to create database table. Please refer to DB11 LITE for further information.

Step 2: Download the demo project at Display visitors local time using C sharp and include into your C Sharp project.

Retrieving country and timezone data from MySQL Database

//Retrieve data from MySQL Database
	protected static string Get_Data(string query)
	{
		//Statement to connect with MySQL Database, replace lower case with actual MySQL configuration
		string db_con_string = "SERVER=server;DATABASE=database;UID=username;PASSWORD=password;";
		using (MySqlConnection con = new MySqlConnection(db_con_string))
		{
			using (MySqlCommand cmd = new MySqlCommand())
			{
				cmd.CommandText = query;
				using (MySqlDataAdapter sda = new MySqlDataAdapter())
				{
					cmd.Connection = con;
					sda.SelectCommand = cmd;
					using (DataSet ds = new DataSet())
					{
						DataTable dt = new DataTable();
						sda.Fill(dt);
						//Assigning data from database into a string
						object timezone = dt.Rows[0]["time_zone"];
						object country_code = dt.Rows[0]["country_code"];
						return Convert.ToString(timezone) + "," + Convert.ToString(country_code);
					}
				}
			}
		}
	}
 

Converting IP address to IP number

	protected System.Numerics.BigInteger ip_to_number(string ip_addr)
	{
		System.Net.IPAddress address;
		System.Numerics.BigInteger ipnum = 0;

		if (System.Net.IPAddress.TryParse(ip_addr, out address))
		{
			byte[] addrBytes = address.GetAddressBytes();

			if (System.BitConverter.IsLittleEndian)
			{
				System.Collections.Generic.List byteList = new System.Collections.Generic.List(addrBytes);
				byteList.Reverse();
				addrBytes = byteList.ToArray();
			}

			if (addrBytes.Length > 8)
			{
				//IPv6
				ipnum = System.BitConverter.ToUInt64(addrBytes, 8);
				ipnum <<= 64;
				ipnum += System.BitConverter.ToUInt64(addrBytes, 0);
			}
			else
			{
				//IPv4
				ipnum = System.BitConverter.ToUInt32(addrBytes, 0);
			}
		}
		return ipnum;
	}

Retrieving UTC time

	protected string utc()
	{
		int utc_h = DateTime.Now.Hour - 8;
		int min = DateTime.Now.Minute;
		if (min < 10)
		{
			string minute = "0" + min;
			return utc_h + ":" + minute;
		}
		else
		{
			return utc_h + ":" + DateTime.Now.Minute;
		}
	}

Retrieving client time

	protected string client(string time_zone)
	{
		string utc_time = utc();
		string[] separator = { ":" };
		string[] time = time_zone.Split(separator, StringSplitOptions.None);
		string[] utc_h = utc_time.Split(separator, StringSplitOptions.None);
		int client_h = Convert.ToInt32(utc_h[0]) + (Convert.ToInt32(time[0]));

		if (client_h >= 24)
		{
			client_h = client_h - 24;
		}
		else if (client_h < 0)
		{
			client_h = client_h + 24;
		}

		if (DateTime.Now.Minute < 10)
		{
			return client_h + ":0" + DateTime.Now.Minute;
		}
		else
		{
			return client_h + ":" + DateTime.Now.Minute;
		}
	}