Hallo zusammen , habe problem nach umstellung "Option Strict On" in zeile 20,weiss nicht wie ich das beseitigen kann.
VB.NET-Quellcode
- Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
- Dim connString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Temp\userDB.accdb"
- Dim myConnection As OleDbConnection = New OleDbConnection
- Dim da As OleDbDataAdapter
- Dim strSQL As String
- Dim ds As DataSet
- Dim firstName As String
- strSQL = "SELECT tblUsers.FirstName FROM tblUsers "
- strSQL = strSQL & "WHERE (tblUsers.userName = '" & (Me.TextBox1.Text) & "' "
- strSQL = strSQL & "And tblUsers.userPassword = '" & (Me.TextBox2.Text) & "');"
- myConnection.ConnectionString = connString
- da = New OleDbDataAdapter(strSQL, myConnection)
- ds = New DataSet
- da.Fill(ds, "users")
- myConnection.Close()
- For Each rowTest In ds.Tables(0).Rows
- firstName = rowTest("FirstName").ToString
- Next
- If firstName <> "" Then
- MessageBox.Show("Hallo " & TextBox1.Text & " Sie sind Eingelogt")
- Else
- MessageBox.Show("Benutzername,Passwort ist Falsch oder Sie sind nicht Registriert!")
- End If
- End Sub