chrome top search url in pc find out c#

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

1 Reply

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

Prem Anandh J7y ago
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