public Boolean SetLocation(string birdname, double longitude, double latitude)
        {
            try
            {
                string myConnString = @"Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=test; User=root;Password=root123;Option=3;";

                OdbcConnection conn = new OdbcConnection(myConnString);
                conn.Open();

                //INSERT INTO `test`.`geolocation` (`idgeoLocation`, `longitude`, `latitude`, `birdname`) VALUES (2, 52, -6.2, 'Blackbird');
                OdbcCommand insert = conn.CreateCommand();

                insert.CommandText = "INSERT INTO geolocation (longitude,latitude,birdname) VALUES(?,?,?)";

                var parameter = new OdbcParameter("longitude", longitude);
                parameter.OdbcType = OdbcType.Double;
                insert.Parameters.Add(parameter);
                parameter = new OdbcParameter("latitude", latitude);
                parameter.OdbcType = OdbcType.Double;
                insert.Parameters.Add(parameter);
                parameter = new OdbcParameter("birdname", birdname);
                parameter.OdbcType = OdbcType.VarChar;
                insert.Parameters.Add(parameter);

                insert.ExecuteNonQuery();


                conn.Close();
                return true;
            }
            catch (Exception)
            {
                return false;
                throw;
            }

        }