开发者

Extracting URL data from moz_places table within Places.Sqlite in C#

I have created a program to copy out the places.sqlite file to USB storage, however I am needing to access this file to extract all URLs from the moz_places table. What would be the 开发者_开发百科best method to achieve this?

Thanks, Jason


It's simple just do this:

SQLiteConnection sqlite_connectionMoz = new SQLiteConnection("Data Source=" + path_to_db + ";Version=3;");
sqlite_Moz = sqlite_connectionMoz.CreateCommand();
                            sqlite_connectionMoz.Open();
sqlite_Moz.CommandText = "SELECT moz_places.url FROM moz_places";`
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜