0

I am doing task to get history of Mozilla Firefox in my desktop application here is my code but i get Error No such table found:moz_places ,I searched out every where but i did't get solution . I get Reference of https://developer.mozilla.org/en-US/docs/Mozilla/Tech/Places/Database and https://www.youtube.com/watch?v=uRKeZSCwlyE

 private void button2_Click(object sender, EventArgs e)
        {

            string Mozilla = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData) + @"\Mozilla\Firefox\Profiles\iv6i2j75.default\places.sqlite";
            SQLiteConnection cn = new SQLiteConnection("Data Source=" + Mozilla + ";Version=3;New=False;Compress=True;");
            cn.Open();
            SQLiteDataAdapter sd = new SQLiteDataAdapter("select url,title,visit_count,last_visit_date from moz_places", cn);
            DataSet ds = new DataSet();
            sd.Fill(ds);
            dataGridView1.DataSource = ds.Tables[0];
            cn.Close();
        }

here is my error snap ..Any Suggestion will appreciated...!!

enter image description here

Erik BRB
  • 215
  • 6
  • 19
Dhaval
  • 2,341
  • 1
  • 13
  • 16
  • close firebox - put the path as hard coded: string Mozilla = "c:/users/u1/....."; - build the project , run it as administrator from windows explorer (not from visual studio)... you can use http://sqlitestudio.pl to open the file and to see if the tables exists or not. – houssam Dec 11 '14 at 12:51
  • possible duplicate of [Add backslash to string](http://stackoverflow.com/questions/16899522/add-backslash-to-string) – CL. Dec 11 '14 at 17:41
  • CL :NO I tried That .... – Dhaval Dec 12 '14 at 03:15

0 Answers0