C # connect to SQLite

Without talking nonsense, go to the subject:

1. SQLite Introduction: lightweight, open-source, and embedded relational databases.

2. Download sqlite-shell-win32

3. sqlite.net download (used for winform and other projects to interact with SQLite and provide DLL connections) PS:. net3.5 download this file. Another. net3.5 test found a problem and encountered an exception.

4. Download The SQLite-GUI tool (SQLite expert professional 3), which is quite powerful and supports importing CSV files.

5. decompress the downloaded SQLite file and reference it to the project. After successful reference, the following message is displayed: (Drinking method: Right-click the project name, add reference, browse, and add it to the Project)

6. Database Connection example:

Time shuttle View

7,C # SQLite error: Unable to load DLL "SQLite. InterOP. dll", unable to find the specified Module

8. traverse the result set

Foreach (datatable DT in datas. Tables)
{
Foreach (datarow DR in DT. Rows)
{
Foreach (datacolumn DC in DT. columns)
{
MessageBox. Show (string. Format ("{0}, {1}, {2}", DT. tablename, DC. columnname, Dr [DC]);
}
}
}