Search results

  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...
  15. D

    Form size not working properly

    Hi, I have a from with a Tabcontrol and inside a Datagridivew. I am using windows 10 and VS 2013 When I launch the form it doesn't size to the size as created in the designer. I checked my code and at no point do I adjust the form size programmatically. I been reading on line and it does seem...
  16. D

    Resolved WinForm API call to return result

    Thank You JohnH I'm looking forward to trying....kind regards
  17. D

    Resolved WinForm API call to return result

    Sorry forgot:sick::sick::sick:
  18. D

    Resolved WinForm API call to return result

    HI, I'm testing an API call from a Winforms, I'm using VS 2013. I've been reading a lost about it and was using an API call to a google website to test, but its very confusing, normally I can figure out what happening and get it going but its all very confusing between the imports the events...
  19. D

    Appointment Calendar for a month on one form

    Well that me told ! 😞😞😞. But thank for your help anyways. Clearly it can be done but with a lot of work and at the moment I don't have the time to reseach all the different Drawstring methods of which there are many!. Not to mention cell boundary and rectangles together with points. It will...
Top Bottom