Private Sub dodaj_pkt()
Dim MySqlConn = New MySqlConnection
MySqlConn.ConnectionString =
"server=sql.s17.vdl.pl;userid=diloyt;password=0logfim12;database=database_yt;allow zero datetime = true;"
Dim READER As MySqlDataReader
Try
MySqlConn.Open()
Dim Query As String
Query = "update user set points=points+0.3 where login='" & TextBox11.Text & "'"
Dim COMMAND As New MySqlCommand(Query, MySqlConn)
READER = COMMAND.ExecuteReader
MySqlConn.Close()
Catch ex As MySqlException
If ex.ToString.ToLower.Contains("authentication to host") Then
MessageBox.Show("Connection Failed. Please download latest application version and try again!")
End If
Finally
End Try
End Sub
chodzi mi o to ze chcialbym aby po tym zapytaniu mysql - aplikacja wykonala kolejne...
Query = "update user set points=points+0.3 where login='" & TextBox11.Text & "'"
nastepnie :
Query = "update user set points=points-0.3 where login='" & TextBox5.Text & "'"
i tu mam pytanie...czy moge to jakos krócej napisać? by zapytania mysql jedno po drugim sie wywoalaly? czy musze to 2 razy powtarzać cały kod?