sqlite3基本操作

添加System.Data.SQLite.dll并在项目属性设置目标框架为.NET 3.5。

            //创建数据库
            SQLiteConnection conn = null;
            conn = new SQLiteConnection("Data Source = test1.db");
            conn.Open();

            //创建表格
            SQLiteCommand cmd = new SQLiteCommand();
            cmd.Connection = conn;
            cmd.CommandText = "create table if not exists buffer(a text,b text)";
            cmd.ExecuteNonQuery();

            //添加数据
            cmd.CommandText = "insert into buffer values(\"facebook\",\"google\")";
            cmd.ExecuteNonQuery();
            cmd.CommandText = "insert into buffer values(\"amazon\",\"microsoft\")";
            cmd.ExecuteNonQuery();

            //选择数据 sdr(很少用到)
            cmd.CommandText = "select * from buffer";
            SQLiteDataReader sdr = cmd.ExecuteReader();

            while (sdr.Read())// 读取其中一行
            {
                //MessageBox.Show(sdr[0].ToString());
                //MessageBox.Show(sdr[1].ToString());                
            }
            sdr.Close();

            // 选择数据 sda
            SQLiteDataAdapter sda = new SQLiteDataAdapter("select * from buffer",conn);
            DataSet ds = new DataSet();
            sda.Fill(ds);
            DataTable ds_dt = ds.Tables[0];

            // 删除记录
            //cmd.CommandText = "delete from buffer";
            //cmd.ExecuteNonQuery();

            // 删除数据表格
            //cmd.CommandText = "drop table buffer";
            //cmd.ExecuteNonQuery();

            conn.Dispose();