C#

1192034 - Import history from Microsoft Edge[^]:

The internet suggests ( http://blogs.msdn.com/b/martinc/archive/2015/02/11/using-esentutl-exe-vss-to-examine-an-in-use-database.aspx[^] ) to make a Volume Shadow Service copy in order to read the database. Doing this from a normal user level produces:

esentutl /mh WebCacheV01.dat /vss

VSS Subsystem Init failed, 0x80070005
Operation terminated with error -2403 (JET_errOSSnapshotNotAllowed, OS Shadow copy not allowed (backup or recovery in progress)) after 0.15 seconds.

Reading:
http://blog.nirsoft.net/2012/12/08/a-few-words-about-the-cache-history-on-internet-explorer-10/[^]

I tried again from a cmd prompt with admin privileges. This worked! Dumping table information failed because the database was not closed (or something, I didn't save the error message).

I ended up using the following magic incantation:

esentutl /y WebCacheV01.dat /vssrec V01 . /d destination\path\for\copy.dat

using (var cmdEsentutl = new Process())
{
    cmdEsentutl.StartInfo.FileName = "esentutl";
    cmdEsentutl.StartInfo.UseShellExecute = false;
    cmdEsentutl.StartInfo.CreateNoWindow = false;
    cmdEsentutl.StartInfo.Arguments = $@"/y {GlobalVariables.edge44HistoryDB}\WebCacheV01.dat /vssrec V01 . /d F:\WebCacheV01.dat";
    cmdEsentutl.StartInfo.Verb = "runas";
    cmdEsentutl.StartInfo.RedirectStandardError = true;
    cmdEsentutl.Start();
    cmdEsentutl.WaitForExit();
}

Microsoft.Office.Interop.Outlook.Application myApp = new Microsoft.Office.Interop.Outlook.ApplicationClass();
            Microsoft.Office.Interop.Outlook.NameSpace mapiNameSpace = myApp.GetNamespace("MAPI");
            Microsoft.Office.Interop.Outlook.MAPIFolder myContacts = mapiNameSpace.GetDefaultFolder(Microsoft.Office.Interop.Outlook.OlDefaultFolders.olFolderContacts);

            //login
            mapiNameSpace.Logon(null, null, false, false);

            mapiNameSpace.Logon("YourOutlookMailID", "Password", Missing.Value, true);


            Microsoft.Office.Interop.Outlook.Items myItems = myContacts.Items;

           // Console.WriteLine("Total : ", myItems.Count);

            Microsoft.Office.Interop.Outlook.MAPIFolder myInbox = mapiNameSpace.GetDefaultFolder(Microsoft.Office.Interop.Outlook.OlDefaultFolders.olFolderInbox);

          //  Console.Write(myInbox.Name);

            Microsoft.Office.Interop.Outlook.Items inboxItems = myInbox.Items;

           // Console.WriteLine("Total : ", inboxItems.Count);

            Microsoft.Office.Interop.Outlook.Explorer myexp = myInbox.GetExplorer(false);

            mapiNameSpace.Logon("Profile", Missing.Value, false, true);



            if (myInbox.Items.Count > 0)
            {
            Console.WriteLine(string.Format("Total Unread message {0}:", inboxItems.Count));
                int x=0;
                foreach (Microsoft.Office.Interop.Outlook.MailItem item in inboxItems)
                {
                    Console.WriteLine("{0} unread mail from your inbox", ++x);
                    Console.WriteLine(string.Format("from:-       {0}", item.SenderName));
                    Console.WriteLine(string.Format("To:-         {0}", item.ReceivedByName));
                    Console.WriteLine(string.Format("Subject:-     {0}", item.Subject));
                    Console.WriteLine(string.Format("Message:-     {0}", item.Body));
                    System.Threading.Thread.Sleep(1000);
                }
                Console.ReadKey();
}

Using package As New ExcelPackage()
    Dim sheet As ExcelWorksheet = package.Workbook.Worksheets.Add("Sheet1")
    sheet.Cells("A1").LoadFromDataTable(dt, True, TableStyles.Medium9)
    
    Response.Clear()
    Response.ContentType = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
    package.SaveAs(Response.OutputStream)
End Using

sw.Write("=""" & Replace(row(column).ToString().Trim(), """", """""") & """" & vbTab)

word1,word2,word3,word4
word1,word5,word7,word4,word6
word3,word4
word5,word6,word7

private int paged = 0;
...
var items = myList.Skip( paged ).Take( 10 );
paged += items.count;
...
// Display items.

devilonline1 wrote:

i cant get it work

XDocument doc = XDocument.Load(@"C:\Work\stores.xml");

var xpath = "//store/Color[text()=]" + X;

var result = ((IEnumerable)doc.XPathEvaluate(xpath)).Cast<XElement>().FirstOrDefault();
textBox1.Text = result.Value;