web browser get search history in data table c#

Question

web browser get search history in data table c# thank you

Amit Mohanty · Answer

Hey try this and make sure that your browser is not running. using System; using System.Collections.Generic; using System.Data; using System.Data.SQLite; using System.IO; namespace History { public class HistoryItem { public string URL { get ; set ; } public string Title { get ; set ; } public DateTime VisitedTime { get ; set ; } } public class BrowseHistory { public List GetHistory() { List allHistoryItems = new List (); 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]; foreach (DataRow historyRow in dt.Rows) { HistoryItem historyItem = new HistoryItem() { URL = Convert.ToString(historyRow[ "url" ]), Title = Convert.ToString(historyRow[ "title" ]) }; long utcMicroSeconds = Convert.ToInt64(historyRow[ "last_visit_time" ]); DateTime gmtTime = DateTime.FromFileTimeUtc(10 * utcMicroSeconds); DateTime localTime = TimeZoneInfo.ConvertTimeFromUtc(gmtTime, TimeZoneInfo.Local); historyItem.VisitedTime = localTime; allHistoryItems.Add(historyItem); } } } return allHistoryItems; } } }

Rajanikant Hawaldar · Answer

Hi Deepak check below https://social.msdn.microsoft.com/Forums/en-US/3e9f3588-ad0b-49af-b269-2abfda0b9abc/how-to-get-the-browser-history-in-program-using-c?forum=csharpgeneral

Deepak Yadav · Answer

All ready applied this code not a get proper result

Deepak Yadav · Answer

Hell Rajnikant sir https://social.msdn.microsoft.com/Forums/en-US/3e9f3588-ad0b-49af-b269-2abfda0b9abc/how-to-get-the-browser-history-in-program-using-c?forum=csharpgeneral This Code already applied but not a working Thank you, sir,