使用.NET操作SQLLITE

时间:2012-08-02 点击:统计中..
先下载ADO.NET2.0 Provider for SQLite。下载binaries zip版就可以了。下载完后解压缩,可以在bin目录下找到System.Data.SQLite.DLL。在vs2008中用Add Refrence功能把System.Data.SQLite.DLL加到工程里就可以了。运行下面代码试试:
  string datasource = "e:/tmp/test.db";
  System.Data.SQLite.SQLiteConnection.CreateFile(datasource);
  //连接数据库
  System.Data.SQLite.SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection();
  System.Data.SQLite.SQLiteConnectionStringBuilder connstr = new System.Data.SQLite.SQLiteConnectionStringBuilder();
  connstr.DataSource = datasource;
  connstr.Password = "admin";//设置密码,SQLite ADO.NET实现了数据库密码保护
  conn.ConnectionString = connstr.ToString();
  conn.Open();
  //创建表
  System.Data.SQLite.SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand();
  string sql = "CREATE TABLE test(username varchar(20),password varchar(20))";
  cmd.CommandText = sql;
  cmd.Connection = conn;
  cmd.ExecuteNonQuery();
  //插入数据
  sql = "INSERT INTO test VALUES('a','b')";
  cmd.CommandText = sql;
  cmd.ExecuteNonQuery();
  //取出数据
  sql = "SELECT * FROM test";
  cmd.CommandText = sql;
  System.Data.SQLite.SQLiteDataReader reader = cmd.ExecuteReader();
  StringBuilder sb = new StringBuilder();
  while (reader.Read())
  {
  sb.Append("username:").Append(reader.GetString(0)).Append("\n")
  .Append("password:").Append(reader.GetString(1));
  }
  MessageBox.Show(sb.ToString());

赞助商链接

热门内容

相关内容



联系我们

联系方式