我找不到VB.NET的文档
尝试使用System.Data.Sqlite修改Sqlite在线备份上答案的代码
@Elias中的代码是:
using(var source = new SQLiteConnection("Data Source=ActiveDb.db; Version=3;"))
using(var destination = new SQLiteConnection("Data Source=BackupDb.db; Version=3;"))
{
source.Open();
destination.Open();
source.BackupDatabase(destination, "main", "main", -1, null, 0);
}
和我的代码看起来像:
Dim conn = New SQLiteConnection("Data Source=MyBase.sqlite;Version=3;Password=myPassword;foreign keys=true")
Dim connbackup = New SQLiteConnection("Data Source=MyBaseBackup.sqlite; Version=3;Password=myPassword;foreign keys=true")
Try
Using (conn)
conn.Open()
connbackup.Open()
conn.BackupDatabase(connbackup, "main", "main", -1, null, 0)
End Using
Catch ex As Exception
MsgBox(ex.ToString())
End Try
没有声明Visual Studio标记为红色的“ Null”,并且我不知道如何解决该错误。我认为是“回调”有什么问题
这是该C#代码的直接翻译:
Using source As New SQLiteConnection("Data Source=ActiveDb.db; Version=3;"),
destination As New SQLiteConnection("Data Source=BackupDb.db; Version=3;")
source.Open()
destination.Open()
source.BackupDatabase(destination, "main", "main", -1, Nothing, 0)
End Using
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句