SQLite更新查询在控制台中工作，而不是在.Net中-SQLiteupdatequeryworksinconsole,notin.Net

I am using an SQLite database in my application. For some reason the query:

我在我的应用程序中使用SQLite数据库。由于某种原因查询：

    UPDATE USERS SET PASSWORD = 'test' WHERE USERNAME = 'Admin'

works in console (updates the PASSWORD field), but when I run it via code:

在控制台中工作（更新PASSWORD字段），但是当我通过代码运行时：

Dim exec As String = "UPDATE USERS SET PASSWORD = '" & password & "' WHERE USERNAME = '" & username & "'"
Dim returnCode As [Boolean] = True
Try
    ExecuteNonQuery(exec)
Catch
    returnCode = False
End Try
Return returnCode

The function always returns false, and the database is not updated. Here is the ExecuteNonQuery method:

该函数始终返回false，并且不更新数据库。这是ExecuteNonQuery方法：

Public Shared Function ExecuteNonQuery(sql As String) As Integer
    Dim cnn As New SQLiteConnection(dbConnection)
    cnn.Open()
    Dim mycommand As New SQLiteCommand(cnn)
    mycommand.CommandText = sql
    Dim rowsUpdated As Integer = mycommand.ExecuteNonQuery()
    cnn.Close()
    Return rowsUpdated
End Function

What am I doing wrong here? My code for creating a new row works fine, but updating doesn't.

我在这做错了什么？我创建新行的代码工作正常，但更新没有。

Yes, I am aware this is unsafe, I originally had a bunch more safety checks, but I need to at least get it to work before doing so.

是的，我知道这是不安全的，我最初有一堆更多的安全检查，但我需要在这之前至少让它工作。

1 个解决方案