关于SQLite的使用

首先引用System.Data.SQLite.dll

//连接

System.Data.SQLite.SQLiteConnection conn=new System.Data.SQLite.SQLiteConnection();

string datasource="e:/test.db";//System.Web.HttpContext.Current.Server.MapPath(@"ClientBin\test.db");

System.Data.SQLite.SQLiteConnection.CreateFile(datasource);

System.Data.SQLite.SQLiteConnectionStringBuilder ssb=new System.Data.SQLiteConnectionStringBuilder();

ssb.DataSource=datasource;

ssb.Password="admin";//在SQLite的编辑器里面打开此数据库的时候 需要命令对数据库的保护

ssb.ConnectionString=ssb.ToString();

conn.open();

System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand();

//创建表

  sql = "CREATE TABLE TEST(USERNAME VARCHAR(20),PASSWORD VARCHAR(20))";                

  cmd.CommandText = sql;                

  cmd.Connection = conn;

  cmd.ExecuteNonQuery();

//新增数据

sql = "INSERT INTO TEST VALUES('A','A111111')";                

 cmd.CommandText = sql;

 cmd.ExecuteNonQuery();

//查询

sql="select * from TEST";

 cmd.Connection = conn;                

 cmd.CommandText = sql;                

 //System.Data.SQLite.SQLiteDataReader reader = cmd.ExecuteReader();                

 System.Data.SQLite.SQLiteDataAdapter dataAdapter = new System.Data.SQLite.SQLiteDataAdapter(cmd);                

 DataSet ds = new DataSet();                

 dataAdapter.Fill(ds);

 可以返回DataSet 或者是 遍历reader