Guten Abend liebe Community,
Und wieder habe ich ein kleiner Fehler diesmal ist es einen MySQL Fehler.
Sobald ich den Code ausführe, kommt folgende Fehlermeldung:
Bei folgendem Code:
Ich hoffe, mir kann jemand weiter helfen.
MFG
Und wieder habe ich ein kleiner Fehler diesmal ist es einen MySQL Fehler.
VB.NET-Quellcode
- Imports MySql.Data.MySqlClient
- Public Class Administration
- Dim MySQL As MySqlConnection
- Dim Adapter As New MySqlDataAdapter
- Dim SQL As String
- Dim Command As New MySqlCommand
- Dim Data As MySqlDataReader
- Public Function OPEN() As Boolean
- Try
- MySQL = New MySqlConnection
- MySQL.ConnectionString = "server=web1.php-friends.de; user id=HoPatri_ext;password=***;database=HoPatrisql11"
- MySQL.Open()
- Return True
- Catch ex As Exception
- Return False
- End Try
- End Function
- Private Sub Administration_Load(sender As Object, e As EventArgs) Handles MyBase.Load
- OPEN()
- If OPEN() = True Then
- SQL = "SELECT * FROM puser"
- Command.Connection = MySQL
- Command.CommandText = SQL
- Adapter.SelectCommand = Command
- Data = Command.ExecuteReader
- If Data.HasRows Then
- listbox_view.Items.Add(Data("username").ToString)
- End If
- Data.Close()
- MySQL.Close()
- Else
- MsgBox("Fehler")
- End If
- End Sub
- Private Sub button_save_Click(sender As Object, e As EventArgs) Handles button_save.Click
- Try
- Catch ex As Exception
- End Try
- SQL = "UPDATE puser SET name' " & text_username.Text & "', email='" & text_mail.Text & "',keycode='" & text_key.Text & "'"
- Command.Connection = MySQL
- Command.CommandText = SQL
- Adapter.SelectCommand = Command
- Data = Command.ExecuteReader
- End Sub
- Private Sub TextBox2_TextChanged(sender As Object, e As EventArgs) Handles text_mail.TextChanged
- End Sub
- Private Sub button_select_Click(sender As Object, e As EventArgs) Handles button_select.Click
- Try
- SQL = "SELECT * FROM puser WHERE username'" & listbox_view.Text & "'"
- Command.Connection = MySQL
- Command.CommandText = SQL
- Adapter.SelectCommand = Command
- Data = Command.ExecuteReader
- If Data.HasRows Then
- text_username.Text = Data("username").ToString
- text_mail.Text = Data("email").ToString
- text_key.Text = Data("key").ToString
- End If
- Catch ex As Exception
- End Try
- End Sub
- Private Sub Label3_Click(sender As Object, e As EventArgs) Handles Label3.Click
- End Sub
- End Class
Sobald ich den Code ausführe, kommt folgende Fehlermeldung:
Bei folgendem Code:
Ich hoffe, mir kann jemand weiter helfen.
MFG