Recent content by divjoy

  1. D

    Option to copy data from remote mySQL through the office firewall

    Hi, I'm not sure what part of the forum to post this as its really help on a desktop app getting data from a mySQL database on a remote webserver using vb.net I am able to connect to an external mySQL database and return the result of a query and store in a win form datagridview. But from my...
  2. D

    Resolved Winform to capture records from an online mySQL db

    So got the remote connections allowed with my IP address and had to open the port 3306 and using the MySqlConnection string builder it all worked! I am delighted! Thanks for help.
  3. D

    Resolved Winform to capture records from an online mySQL db

    So my code so far is as follows, but doesn't return that data, I get "Cannot connect to server. Contact administrator" what am I doing wrong ? Imports System Imports System.Data Imports MySql.Data.MySqlClient Public Class FrmMySQLData Private ConnStr As String = "" Private conn As...
  4. D

    Resolved Winform to capture records from an online mySQL db

    Thanks for advice jmcilhinney. Now have to code it! anyone done something similar I can use as a template?
  5. D

    Resolved Winform to capture records from an online mySQL db

    Hi, I designing a winform application to capture data stored in a mySQL db on my https website. I am not sure whether to access the mySQL db directly (if I can) or goto a webpage and read the records from it? I have the passwords for both It seems more logical to go straight to the db and...
  6. D

    Resolved Google map API call from winform

    Hi, Got it working thanks, I'm using Eircodes from Ireland so had to add +ire to the string! But thanks for your help worked a treat!
  7. D

    Resolved Google map API call from winform

    Tried this but comig back with error... Dim response = Newtonsoft.Json.JsonConvert.DeserializeObject(Of Response)(content) TextBox1.Text = response.status TextBox2.Text = response.rows(0).elements(0).distance.value Error on last line Object Ref not set to instance of object...
  8. D

    Resolved Google map API call from winform

    So here is the VB.net class code.... Class ValuePair Public Property value As Integer Public Property text As String End Class Class Element Public Property status As String Public Property duration As ValuePair Public Property distance As...
  9. D

    Resolved Google map API call from winform

    I understand that John but you first have to assign the class structure to match and then use the reader to read each element...
  10. D

    Resolved Google map API call from winform

    JSON object looks like this.... { "status":"OK", "origin_addresses":[ "Vancouver, BC, Canada", "Seattle, État de Washington, États-Unis" ], "destination_addresses":[ "San Francisco, Californie, États-Unis", "Victoria, BC, Canada" ], "rows":[ {...
  11. D

    Resolved Google map API call from winform

    So here is my code so far, cant get access to the json object fields. I am getting back OK from the API, but need to traverse the fields... Imports System.IO Imports System.Net Imports System.Net.Http Imports Newtonsoft.Json Public Class Form1 Private API_Key As String = "xxxx"...
  12. D

    Resolved Google map API call from winform

    Private Async Sub Button2_Click(sender As Object, e As EventArgs) Handles Button1.Click Dim address = "https://us-central1-dadsofunny.cloudfunctions.net/DadJokes/random/jokes" Using client As New Net.Http.HttpClient(), result = Await client.GetAsync(address) If...
  13. D

    Resolved Google map API call from winform

    I have a winform app and want to add a call a Google API with two or more postcodes and I want the API to return the driving distance between these 2 or more point. I intend to use net.http and newtonsoft JSON object. JohnH posted code for an earlier answer that should help me. The API on...
  14. D

    Resolved WinForm API call to return result

    Hi JohnH, That worked a treat, still not sure how it all works tbh. Will the same code work with google api, I am planning now on passing a list of postcodes to google maps to get the road distance between them all ! I am also wondering if I setup a databse in Azure would it be safe and...
Top Bottom