Imports MySql.Data.MySqlClient
Public Class Form3
Public con As New MySqlConnection
Public cmd As New MySqlCommand
Public reader As MySqlDataReader
Public Sub Provider()
con.ConnectionString = "server=serverip;" & "user id=name;" & "password=pw;" & "database=datenbank"
cmd.Connection = con
End Sub
Private Sub Form3_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
Timer1.Start()
End Sub
Private Sub KryptonButton1_Click(sender As System.Object, e As System.EventArgs) Handles KryptonButton1.Click
End Sub
Private Sub Label1_Click(sender As System.Object, e As System.EventArgs) Handles Label1.Click, Label2.Click
End Sub
Private Sub Timer1_Tick(sender As System.Object, e As System.EventArgs) Handles Timer1.Tick
Try
con.Open()
cmd.CommandText = "SELECT * FROM benutzer"
reader = cmd.ExecuteReader
Do While reader.Read
Label2.Text = reader("Rang")
Loop
reader.Close()
con.Close()
Catch ex As Exception
con.Close()
MsgBox(ex.Message)
End Try
Timer1.Stop()
End Sub
End Class
So, jetzt hab ich das, stimmt auch alles mit den Namen usw.. aber es kommt die Fehler Meldung ausm Anhang.. Hilfe O.o
Public Class Form3
Public con As New MySqlConnection
Public cmd As New MySqlCommand
Public reader As MySqlDataReader
Public Sub Provider()
con.ConnectionString = "server=serverip;" & "user id=name;" & "password=pw;" & "database=datenbank"
cmd.Connection = con
End Sub
Private Sub Form3_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
Timer1.Start()
End Sub
Private Sub KryptonButton1_Click(sender As System.Object, e As System.EventArgs) Handles KryptonButton1.Click
End Sub
Private Sub Label1_Click(sender As System.Object, e As System.EventArgs) Handles Label1.Click, Label2.Click
End Sub
Private Sub Timer1_Tick(sender As System.Object, e As System.EventArgs) Handles Timer1.Tick
Try
con.Open()
cmd.CommandText = "SELECT * FROM benutzer"
reader = cmd.ExecuteReader
Do While reader.Read
Label2.Text = reader("Rang")
Loop
reader.Close()
con.Close()
Catch ex As Exception
con.Close()
MsgBox(ex.Message)
End Try
Timer1.Stop()
End Sub
End Class
So, jetzt hab ich das, stimmt auch alles mit den Namen usw.. aber es kommt die Fehler Meldung ausm Anhang.. Hilfe O.o
Dieser Beitrag wurde bereits 1 mal editiert, zuletzt von „Marcus Gräfe“ ()