Test SQLite [. NET 2.0 applications]

SQLite is a lightweight embedded file-type database. The following is an application attempt in. NET 2.0.

Tools used:
SQLite expert SQLite database management tool, very easy to use, similar to the EMS SQL Manager 2007 for MySQL I introduced earlier
System. Data. SQLite for ADO. Net driver, similar to MySQL. Data. dll
Both tools include the SQLite engine.

Use SQLite expert to create databases and tables
 

New Field
 

Browse data
 

For SQL queries, the syntax seems to be a little like that of MySQL.
 

In ASP. NET 2.0, create a website and reference system. Data. SQLite. dll. Code Example: Sqliteconnection con =   New Sqliteconnection ( @" Data Source = "   + Server. mappath ( " App_data " ) +   " /Book. db3 " );
Sqlitecommand cmd =   New Sqlitecommand ( " Select * From ezbook order by ID " , Con );
Con. open ();
Sqlitedatareader Dr = Cmd. executereader (commandbehavior. closeconnection );
Gridview1.datasource = Dr;
Gridview1.databind ();
Dr. Close ();

Appendix: Example sqlite_net_demo in this article