Sqlite?????????
???????????? ???????[ 2014/1/22 9:48:09 ] ????????Sqlite ?????
????1?????????sqlite?????
//??????????????????????????????к????????
//????????????????sqlite???????IO????
FileStream fs = File.Create(“c:\test.db“);
//??????????SQLiteConnection
SQLiteConnection.CreateFile(“c:\test.db“);
??????????????????0?????????
????2????????????sqlite?????
????//????????????password????sqlite?????
SQLiteConnection.CreateFile??“c:\test2.db“);
SQLiteConnection cnn = new SQLiteConnection(“Data Source=c:\test2.db“);
SQLiteConnection cnn = new SQLiteConnection(“Data Source=D:\test2.db“);
cnn.Open();
cnn.ChangePassword(“password“);
????3????δ?????????????
SQLiteConnection cnn = new SQLiteConnection(“Data Source=c:\test.db“);
cnn.Open();
cnn.ChangePassword(“password“);
????4????????sqlite?????
//?????
SQLiteConnection cnn = new SQLiteConnection(“Data Source=c:\test2.db“);
cnn.SetPassword(“password“);
cnn.Open();
//??????
SQLiteConnectionStringBuilder builder = new SQLiteConnectionStringBuilder();
builder.DataSource = @”c: est.db“;
builder.Password = @”password“;
SQLiteConnection cnn = new SQLiteConnection(builder.ConnectionString);
cnn .Open();
???????
????select * from messages limit 10??100;
???????????10?У??100?е????????
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11