Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private bool ExecuteSQLQuery(string filename, string filesize)
- {
- String query = "SELECT * FROM local_entry WHERE ";
- query += "filename =\"" + filename + "\" ";
- query += "filesize =" + filesize + " ";
- var results = GetDataTable(query);
- if (results.Rows.Count > 0)
- {
- return true;
- }
- return false;
- }
- private void Comparebutton_Click(object sender, EventArgs e)
- {
- sqlite = new SQLiteConnection("Data Source=" + Dbpath.Text);
- List<KeyValuePair<string, string>> validData = new List<KeyValuePair<string, string>>();
- XDocument doc = XDocument.Load(XMLpath.Text);
- if (doc != null)
- {
- var items = doc.Element("chrome_cache").Elements("item");
- foreach (var item in items)
- {
- string filename = item.Element("filename").Value;
- string filesize = item.Element("file_size").Value;
- if (filename != "")
- {
- if (SQLQuery(filename, filesize))
- validData.Add( new KeyValuePair<string, string>(filename, filesize) );
- }
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement