免费视频淫片aa毛片_日韩高清在线亚洲专区vr_日韩大片免费观看视频播放_亚洲欧美国产精品完整版

1、下載System.Data.SQLite.DLL,下載地址：
ADO.NET 2.0 Provider for SQLite - Browse /SQLite for ADO.NET 2.0 at SourceForge.net
http://sourceforge.net/projects/sqlite-dotnet2/files/SQLite%20for%20ADO.NET%202.0/
安裝后會在C:\Program Files\SQLite.NET\bin\CompactFramework下面有 System.Data.SQLite.dll 和SQLite.Interop.066.DLL兩個文件
在VS2008項目中引用System.Data.SQLite.DLL即可。

2、創(chuàng)建表、讀取數(shù)據等操作

using System.Data; 
using System.Data.SQLite; 

        private void BtnGetData_Click(object sender, EventArgs e)
        {
            //創(chuàng)建一個空數(shù)據庫
            string datasource=System.IO.Path.GetDirectoryName(Assembly.GetExecutingAssembly().GetName().CodeBase) +"\test.db";  //數(shù)據庫文件放在了程序運行根目錄下

            SQLiteConnection.CreateFile(datasource);            
            

           //連接數(shù)據庫
            SQLiteConnection conn = new System.Data.SQLite.SQLiteConnection();

            conn.ConnectionString = "Data Source=" + datasource + ";Pooling=true;FailIfMissing=false";
            conn.Open();
            

            //創(chuàng)建表
            SQLiteCommand cmd = new System.Data.SQLite.SQLiteCommand();
            string sql = "CREATE TABLE users(username varchar(20),password varchar(20))";
            cmd.CommandText=sql;
            cmd.Connection=conn;
            cmd.ExecuteNonQuery();
            

            //插入數(shù)據
            sql = "INSERT INTO [users] VALUES('AAA','123556')";
            cmd.CommandText = sql;
            cmd.ExecuteNonQuery();
           

            //取出數(shù)據
            sql = "SELECT * FROM [users]";
            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");
                sb.Append("password:").Append(reader.GetString(1));
            }
            MessageBox.Show(sb.ToString());
        }

注意：
程序編譯完后需要將安裝后的兩個DLL文件復制到WINCE的程序運行目錄下，即：System.Data.SQLite.dll和SQLite.Interop.066.DLL（該文件需要更名為SQLite.Interop.DLL）