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...
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 ?
Public Class FrmMySQLData
Private ConnStr As String = ""
Private conn As...
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...
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...
So here is the VB.net class code....
Public Property value As Integer
Public Property text As String
Public Property status As String
Public Property duration As ValuePair
Public Property distance As...
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...
Public Class Form1
Private API_Key As String = "xxxx"...
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)
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...
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...