SQLite数据库操作

一、SQLiteConnection

1、创建db数据库文件

strDBPath = "E:\\xxx.db";

SQLiteConnection.CreateFile(strDBPath);

2、打开数据库链接

SQLiteConnection ipConn = new SQLiteConnection();

SQLiteConnectionStringBuilder connstr = new SQLiteConnectionStringBuilder();
connstr.DataSource = _strDbPath;

//设置访问密码

if (!string.IsNullOrEmpty(strPsw))
     {
           connstr.Password = _strPsw; 

      }

ipConn.ConnectionString = connstr.ConnectionString;

ipConn.Open();

3、关闭数据库链接

ipConn.Close();

待补充.......................