web browser get search history in data table c#

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;
}
}
}

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

7y ago
All ready applied this code not a get proper result
Amit Mohanty7y ago
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;
        }
    }
}
7y ago
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,
Rajanikant Hawaldar7y ago
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