[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 523
  • Last Modified:

vb.net ado mysql

currently got working code for send data to a csv
Public outfile
...
..
..
Private Sub csv_handler()
        Dim csv_out_string As String
        ''''''''outfile at 5min intervals
        csv_out_string = String.Format("{0:g},{1:00.00},{2:00.00},{3:00.00}", DateTime.Now, x1, x2, x3)
        outfile.writeline(csv_out_string)
        outfile.flush()
    End Sub

Now I want to write that to a mysql database table using ado.net and vb.net express edition

please help
0
IanTh
Asked:
IanTh
  • 3
  • 3
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
well, the only issue you need to ensure is that for MySQL, the datetime must be in format 'YYYY-MM-DD' and with time 'YYYY-MM-DD HH:MI:SS'
0
 
IanThAuthor Commented:
but what code do I use I am fairly familiar with mysql dataset and tables from a web design perspective but not from vb.net so I need to know how to connect and update the data first

I do have a timer setup for 5 mins if thats relevant
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
IanThAuthor Commented:
that mentions 2005 not 2008 will it still work I thought It had to use ado.net too
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
ado.net will also work in vs 2008
0
 
IanThAuthor Commented:
abandoned going c# on linux via mono
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now