Dim conn = New MySqlConnection()
conn.ConnectionString = "server=" & dbServer & ";" _
& "user id=" & dbUser & ";" _
& "password=" & dbpassword & ";" _
& "database=" Dim conn = New MySqlConnection()
conn.ConnectionString = "server=" & dbServer & ";" _
& "user id=" & dbUser & ";" _
& "password=" & dbpassword & ";" _
& "database=" & dbDb
Dim myCommand As New MySqlCommand
myCommand.Connection = conn
myCommand.CommandText = SQL
conn.Open()
myCommand.Parameters.AddWithValue("?fldvideoNo", id)
myCommand.Parameters.AddWithValue("??fldTopicNo", topNo)
myCommand.Parameters.AddWithValue("?File", rawdata)
myCommand.Parameters.AddWithValue("?size", filesize)
myCommand.ExecuteNonQuery()
conn.Close()
conn.Dispose()
myCommand.Dispose()& dbDb
Dim myCommand As New MySqlCommand
myCommand.Connection = conn
myCommand.CommandText = SQL
conn.Open()
myCommand.Parameters.AddWithValue("?fldvideoNo", id)
myCommand.Parameters.AddWithValue("??fldTopicNo", topNo)
myCommand.Parameters.AddWithValue("?File", rawdata)
myCommand.Parameters.AddWithValue("?size", filesize)
myCommand.ExecuteNonQuery()
conn.Close()
conn.Dispose()
myCommand.Dispose()