Connection must be valid and open

  • VB.NET

Es gibt 1 Antwort in diesem Thema. Der letzte Beitrag () ist von picoflop.

    Connection must be valid and open

    Bei diesem Code:

    VB.NET-Quellcode

    1. mysqlconectipn = New MySqlConnection
    2. mysqlconectipn.ConnectionString = "server=db4free.net;Port=3306; user id=*****; Password=******; database=mapple"
    3. mysqlconectipn.Open()
    4. Dim myadapter As New MySqlDataAdapter
    5. Dim sqlquery = "SELECT * From Users WHERE Username='" & UsernameTextBox.Text & "' AND Password='" & PasswordTextBox.Text & "';"
    6. Dim command As New MySqlCommand
    7. command.Connection = New MySqlConnection
    8. command.CommandText = sqlquery
    9. myadapter.SelectCommand = command
    10. Dim data As MySqlDataReader
    11. data = command.ExecuteReader
    12. If data.HasRows = 0 Then
    13. MsgBox("!!!!!")
    15. Else
    16. MsgBox("2")
    17. End If

    bekomme ich hier die fehler meldung : Connection must be valid and open

    VB.NET-Quellcode

    1. data = command.ExecuteReader

Facebook