Dim strConnect As String = "User ID=" + strUser + ";Password=" + strPass + ";Initial Catalog=testdb;Data Source=DBSERVER1"
Dim conn As New SqlConnection(strConnect)
Dim myReaderUserName As SqlDataReader()
Dim mySqlCommandUserName As SqlCommand
mySqlCommandUserName = New SqlCommand("Select USER_PASS from USER where USER_NAME='" + strUser + "'", conn)
Try
conn.Open()
myReaderUserName = mySqlCommandUserName.ExecuteScalar
Me.UserName.Text = myReaderUserName.GetValue("USER_PASS")
Catch e As Exception
Response.Write(e.Message)
End Try
Beim ausführen konnte der folgende Fehlermeldung:
Incorrect syntax near the keyword 'USER'.
Dim conn As New SqlConnection(strConnect)
Dim myReaderUserName As SqlDataReader()
Dim mySqlCommandUserName As SqlCommand
mySqlCommandUserName = New SqlCommand("Select USER_PASS from USER where USER_NAME='" + strUser + "'", conn)
Try
conn.Open()
myReaderUserName = mySqlCommandUserName.ExecuteScalar
Me.UserName.Text = myReaderUserName.GetValue("USER_PASS")
Catch e As Exception
Response.Write(e.Message)
End Try
Beim ausführen konnte der folgende Fehlermeldung:
Incorrect syntax near the keyword 'USER'.
Comment