10-10-17, 07:03 PM
(10-10-17, 10:36 AM)a.ahmed كتب :PHP كود :
Dim cmdlid As New SQLiteCommand(" UPDATE [DBSetting] SET [score]=([score]+@score) WHERE ([contestnyear]=@contestnyear) ", conlid)
cmdlid.Parameters.AddWithValue("@score", xtotelall + xtotelall2)
cmdlid.Parameters.AddWithValue("@contestnyear", contestnyearx)
If conlid.State <> ConnectionState.Open Then conlid.Open()
Dim ret As Integer = cmdlid.ExecuteNonQuery()
conlid.Close()
If ret > 0 Then
MsgBox("Updated.", MsgBoxStyle.Information)
Else
MsgBox("Nothing.", MsgBoxStyle.Exclamation)
End If
احسنت يا بطل بارك الله فيك

