資源簡介
C# .net framwork 3.5 開發,源碼,Sqlite數據庫簡單應用實例 C#中Sqlite數據庫的創建、打開、建表、插入數據、提取數據 在Form DataGridView中顯示Sqlite數據庫內容 附最新System.Data.SQLite.Dll 適合初學者
提示:64位的Win7、win8 解決方案的生成目標平臺設置為x86
32位操作系統 解決方案的生成目標平臺設置為AnyCPU
否則可能會報 “未能加載文件或程序集“XXX”或它的某一個依賴項。試圖加載格式不正確的程序” 錯誤
代碼片段和文件信息
using?System;
using?System.Data;
using?System.Data.SQLite;
using?System.Text;
using?System.Windows.Forms;
namespace?SqliteView
{
????public?partial?class?FormView?:?Form
????{
????????System.Data.SQLite.SQLiteConnection?CONN?=?new?System.Data.SQLite.SQLiteConnection();
????????System.Data.SQLite.SQLiteConnectionStringBuilder?CONNStr?=?new?System.Data.SQLite.SQLiteConnectionStringBuilder();
????????System.Data.SQLite.SQLiteCommand?CMD?=?new?System.Data.SQLite.SQLiteCommand();
????????System.Data.SQLite.SQLiteDataAdapter?DA?=?new?SQLiteDataAdapter();
????????System.Data.DataSet?DS?=?new?DataSet(“DS1“);
????????string?DataSource?=?““;
????????string?SQL?=?““;
????????public?FormView()
????????{
????????????InitializeComponent();
????????????this.textBox1.Text?=?“s
?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2012-07-27?15:57??SqliteView\
?????目錄???????????0??2012-07-27?21:33??SqliteView\SqliteView\
?????文件?????????924??2012-07-27?14:54??SqliteView\SqliteView.sln
?????文件???????24064??2012-07-27?21:00??SqliteView\SqliteView.suo
?????目錄???????????0??2012-07-27?14:54??SqliteView\SqliteView\bin\
?????目錄???????????0??2012-07-27?21:34??SqliteView\SqliteView\bin\Debug\
?????文件??????142336??2012-07-27?21:31??SqliteView\SqliteView\bin\Debug\demo.db
?????文件??????184320??2012-05-28?04:27??SqliteView\SqliteView\bin\Debug\SQLite.Designer.dll
?????文件??????290304??2012-05-28?04:27??SqliteView\SqliteView\bin\Debug\SQLite.Designer.pdb
?????文件???????17118??2012-05-28?04:27??SqliteView\SqliteView\bin\Debug\SQLite.Designer.xm
?????文件???????11776??2012-07-27?21:33??SqliteView\SqliteView\bin\Debug\SqliteView.exe
?????文件???????26112??2012-07-27?21:33??SqliteView\SqliteView\bin\Debug\SqliteView.pdb
?????文件???????14328??2012-07-27?21:34??SqliteView\SqliteView\bin\Debug\SqliteView.vshost.exe
?????文件?????????490??2007-07-21?01:33??SqliteView\SqliteView\bin\Debug\SqliteView.vshost.exe.manifest
?????文件???????25592??2007-11-07?10:21??SqliteView\SqliteView\bin\Debug\stdole.dll
?????文件??????964096??2012-05-28?04:26??SqliteView\SqliteView\bin\Debug\System.Data.SQLite.dll
?????文件??????192512??2012-05-28?04:27??SqliteView\SqliteView\bin\Debug\System.Data.SQLite.Linq.dll
?????文件??????200192??2012-05-28?04:27??SqliteView\SqliteView\bin\Debug\System.Data.SQLite.Linq.pdb
?????文件??????109549??2012-05-28?04:27??SqliteView\SqliteView\bin\Debug\System.Data.SQLite.Linq.xm
?????文件?????2812928??2012-05-28?04:26??SqliteView\SqliteView\bin\Debug\System.Data.SQLite.pdb
?????文件??????241652??2012-05-28?04:27??SqliteView\SqliteView\bin\Debug\System.Data.SQLite.xm
?????文件????????2048??2012-07-27?21:34??SqliteView\SqliteView\bin\Debug\tmp_demo.db
?????文件???????????0??2012-07-27?21:00??SqliteView\SqliteView\bin\Debug\分詞詞典.sqlite
?????目錄???????????0??2012-07-27?20:59??SqliteView\SqliteView\bin\Release\
?????文件????????4908??2012-07-27?21:33??SqliteView\SqliteView\FormView.cs
?????文件????????5024??2012-07-27?21:32??SqliteView\SqliteView\FormView.Designer.cs
?????文件????????5814??2012-07-27?21:32??SqliteView\SqliteView\FormView.resx
?????目錄???????????0??2012-07-27?14:54??SqliteView\SqliteView\obj\
?????目錄???????????0??2012-07-27?21:33??SqliteView\SqliteView\obj\Debug\
?????目錄???????????0??2012-07-27?14:54??SqliteView\SqliteView\obj\Debug\Refactor\
?????文件????????1832??2012-07-27?21:34??SqliteView\SqliteView\obj\Debug\SqliteView.csproj.FileListAbsolute.txt
............此處省略25個文件信息
評論
共有 條評論