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
LVL 30
IanThAsked:
Who is Participating?
 
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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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]Connect With a Mentor Billing EngineerCommented:
ado.net will also work in vs 2008
0
 
IanThAuthor Commented:
abandoned going c# on linux via mono
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.