C # access the SQLite Database

1. download the latest version of SQLite (http://www.sqlite.org/download.html), other versions can also.

A. Copy C:/sqlite-3_5-0 after decompression

B. Enter cmd mode, enter the sqlite-3_5_0 directory, and execute sqlite3 mytest. DB

C. Create Table mytable1 (SEQ int, DESC varchar (8); insert into mytable1 values (1, 'project'); Data creation complete

2. Download System. Data. SQLite (http://sqlite.phxsoftware.com/), install

3. Open vs2005 and refer to system. Data. SQLite. dll in the installation directory of system. Data. SQLite.

Sqliteconnection CNN =   New Sqliteconnection ();
CNN. connectionstring =   @" Data Source = C: sqlite-3_5_0mytest.db " ;
CNN. open ();

Sqlitecommand cmd =   New Sqlitecommand ();
Cmd. Connection = CNN;
Cmd. commandtext =   " Select * From mytable1 " ;
Sqlitedataadapter da =   New Sqlitedataadapter ();
Da. selectcommand = CMD;
Dataset DS =   New Dataset ();
Da. Fill (DS );