easyboot的专栏

Sqlitehelper中的方法。

select --ROWID ,(select count(*) from VisionTemplate b where a.id >= b.id) as row_number ,* from VisionTemplate as a order by id;

1 从NuGet包中添加2.github源码地址https://github.com/praeclarum/sqlite-netC# 操作代码 private void Button_Click_3(object sender, RoutedEventArgs e) { string databasePath = System.AppDomain.CurrentDomain.BaseDirectory + "db/mydb.db...

1.工具下载地址1SQLite Download Page2.解压后，双击sqlite.exe输入 .open mydb.db3.在当前目录下就可以看到db文件了