chrome top search url in pc find out c#

Question

chrome topmost search URL by user in pc find out c#

Prem Anandh J · Answer

1. Add SQLite dll in your project 2. Close Chrome. 3. Try following code public class HistoryItem { public string URL { get ; set ; } public string Title { get ; set ; } public DateTime VisitedTime { get ; set ; } } static class Program { static void Main() { string chromeHistoryFile = Environment.GetFolderPath(Environment.SpecialFolder.LocalApplicationData)) + @ "\Google\Chrome\User Data\Default\History" ; if (File.Exists(chromeHistoryFile)) { SQLiteConnection connection = new SQLiteConnection ( "Data Source=" + chromeHistoryFile + ";Version=3;New=False;Compress=True;" ); connection.Open(); DataSet dataset = new DataSet(); SQLiteDataAdapter adapter = new SQLiteDataAdapter ( "select * from urls order by last_visit_time desc" , connection); adapter.Fill(dataset); if (dataset != null && dataset.Tables.Count > 0 & dataset.Tables[0] != null ) { DataTable dt = dataset.Tables[0]; allHistoryItems = new List (); foreach (DataRow historyRow in dt.Rows) { HistoryItem historyItem = new HistoryItem(); { URL = Convert.ToString(historyRow[ "url" ]), Title = Convert.ToString(historyRow[ "title" ]) }; // Chrome stores time elapsed since Jan 1, 1601 (UTC format) in microseconds long utcMicroSeconds = Convert.ToInt64(historyRow[ "last_visit_time" ]); // Windows file time UTC is in nanoseconds, so multiplying by 10 DateTime gmtTime = DateTime.FromFileTimeUtc(10 * utcMicroSeconds); // Converting to local time DateTime localTime = TimeZoneInfo.ConvertTimeFromUtc(gmtTime, TimeZoneInfo.Local); historyItem.VisitedTime = localTime; allHistoryItems.Add(historyItem); } } } } } Mark as Answered if you got the solutions

chrome top search url in pc find out c#

Answers (1)