开发者

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

开发者 https://www.devze.com 2023-02-16 05:50 出处:网络
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 开发者_开发百科bes

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

精彩评论

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