Pa ovako to radis:
Code:
Imports MySql.Data.MySqlClient
Code:
Dim conn As New MySqlConnection
Dim myCommand As New MySqlCommand
conn.ConnectionString = myConnString
myCommand.Connection = conn
myCommand.CommandText = "INSERT INTO event(sifra, naziv, kolicina)" _
& "VALUES(?sifra, ?naziv, ?kolicina)"
Dim sifra As String = TextBox1.Text
Dim naziv As String = TextBox2.Text
Dim kolicina As Integer = TextBox3.Text
myCommand.Parameters.Add("?sifra", sifra)
myCommand.Parameters.Add("?naziv", naziv)
myCommand.Parameters.Add("?kolicina", kolicina)
Try
conn.Open()
myCommand.ExecuteNonQuery()
Catch myerror As MySqlException
MsgBox("Error: " & myerror.Message)
End Try
cmdRefresh.PerformClick()
Poz
sale
Sto mozes danas ne ostavljaj za sutra!