System.Data.Sqlite 上手指南
System.Data.Sqlite入手。。。
首先import/using:
代码
- using System.Data.SQLite;
Connection和Command:
代码
- private SQLiteConnection conn;
- private SQLiteCommand cmd;
连接db:
代码
- conn = new SQLiteConnection("Data Source=c:\\test.db");
- conn.Open();
INSERT/UPDATE:
代码
- cmd = conn.CreateCommand();
- cmd.CommandText = "INSERT INTO user(email,name) VALUES ('email','name')";
- cmd.ExecuteNonQuery();
- cmd.CommandText = "UPDATE userSET name = 'Codelicious' WHERE ID = 1";
- cmd.ExecuteNonQuery();
SELECT:
代码
- cmd.CommandText = "SELECT ID, name FROM user";
- SQLiteDataReader reader = cmd.ExecuteReader();
- if (reader.HasRows)
- {
- while (reader.Read())
- {
- Console.WriteLine("ID: " + reader.GetInt16(0));
- Console.WriteLine("name: " + reader.GetString(1));
- }
- }