Is there a conversion program to convert VB.net connections from SQL 2014 server to mysql.
I use connectionStrings from Web.config file can you change them to Mysql and work in my VB.net code.
I use select, Insert, update, delete in my code and RDLC Reporting also Gridviews, Data tables.
Dim con As New SqlConnection(ConnString)
Using sqlComm = New SqlCommand()
With sqlComm
If con.State = ConnectionState.Open Then con.Close()
con.Open()
.CommandText = "Select *From SchoolImport Where ImportCode='Free'"
.Connection = con
.CommandType = CommandType.Text
.Parameters.Clear()
Dim reader As SqlDataReader = .ExecuteReader
Do While reader.Read = True
Loop