Databases
StackOverflow2013
Postsdbo
POc# - importing xml file
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POc# - importing xml file
    primarykey
    data
    text
    <p>In my project I have got a listview filled with contacts which are stored in a XML file. </p> <p>This is the connection between the two of these and basically this is how the contacts are loaded:</p> <p>Please note that first function is called on form loading:</p> <pre><code>void LoadContacts() { string path = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData); string phonebook_path = path + "\\Phonebook\\Contacts.xml"; if (!File.Exists(phonebook_path)) { XmlTextWriter xW = new XmlTextWriter(phonebook_path, Encoding.UTF8); xW.WriteStartElement("People"); xW.WriteEndElement(); xW.Close(); } XmlDocument xDoc = new XmlDocument(); xDoc.Load(phonebook_path); foreach (XmlNode xNode in xDoc.SelectNodes("People/Person")) { Person p = new Person(); p.Name = xNode.SelectSingleNode("Name").InnerText; p.Hometown = xNode.SelectSingleNode("Hometown").InnerText; p.Address = xNode.SelectSingleNode("Address").InnerText; p.Birthday = DateTime.FromFileTime(Convert.ToInt64(xNode.SelectSingleNode("Birthday").InnerText)); p.Phone = xNode.SelectSingleNode("Phone").InnerText; p.Email = xNode.SelectSingleNode("Email").InnerText; p.AdditionalInfo = xNode.SelectSingleNode("AdditionalInfo").InnerText; people.Add(p); listView1.Items.Add(p.Name); UserCount(); } } </code></pre> <p>and then the other one on form closing:</p> <pre><code>private void Main_FormClosing(object sender, FormClosingEventArgs e) { XmlDocument xDoc = new XmlDocument(); string path = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData); string phonebook_path = path + "\\Phonebook\\Contacts.xml"; xDoc.Load(phonebook_path); XmlNode xNode = xDoc.SelectSingleNode("People"); xNode.RemoveAll(); foreach (Person p in people) { XmlNode xTop = xDoc.CreateElement("Person"); XmlNode xName = xDoc.CreateElement("Name"); XmlNode xHometown = xDoc.CreateElement("Hometown"); XmlNode xAddress = xDoc.CreateElement("Address"); XmlNode xBirthday = xDoc.CreateElement("Birthday"); XmlNode xPhone = xDoc.CreateElement("Phone"); XmlNode xEmail = xDoc.CreateElement("Email"); XmlNode xAdditionalInfo = xDoc.CreateElement("AdditionalInfo"); xName.InnerText = p.Name; xHometown.InnerText = p.Hometown; xAddress.InnerText = p.Address; xBirthday.InnerText = p.Birthday.ToFileTime().ToString(); xPhone.InnerText = p.Phone; xEmail.InnerText = p.Email; xAdditionalInfo.InnerText = p.AdditionalInfo; xTop.AppendChild(xName); xTop.AppendChild(xHometown); xTop.AppendChild(xAddress); xTop.AppendChild(xBirthday); xTop.AppendChild(xPhone); xTop.AppendChild(xEmail); xTop.AppendChild(xAdditionalInfo); xDoc.DocumentElement.AppendChild(xTop); } xDoc.Save(phonebook_path); Sync(); SetStartup(); } </code></pre> <p>I have got an option to import the XML file via method Import() which is called when a button is clicked. </p> <pre><code>void Import() { Main f1 = new Main(); OpenFileDialog BrowseFile = new OpenFileDialog(); if (BrowseFile.ShowDialog() == System.Windows.Forms.DialogResult.OK) { Properties.Settings.Default.ImportPath = BrowseFile.FileName; } string fileName = "Contacts.xml"; string path = Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData); string sourcePath = Properties.Settings.Default.ImportPath; string targetPath = path + "\\Phonebook\\"; string destFile = System.IO.Path.Combine(targetPath, fileName); System.IO.File.Copy(sourcePath, destFile, true); MessageBox.Show("Contacts have successfully been imported. Please restart your application in order changes to take effect!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information); } </code></pre> <p>...Importing is performed perfectly which means I can see the copied XML file in the right place, but when I close the application, all of a sudden XML file turns into previous state somehow which means changes didn't take effect - when I load the app again, there will be no imported contacts. </p> <p>How can I solve this issue?</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USExinta Enea
    1. USExinta Enea
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POc# - importing xml file
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. POc# - importing xml file
      1. This table or related slice is empty.
      1. VTDownMod
    1. COLittle confused why you bother loading the file in the form close event.
      singulars
      1. POc# - importing xml file
      1. USSam Axe
    2. COThe code (in the Closing) is putting the data back into some "previous state". It's not happening automatically.
      singulars
      1. POc# - importing xml file
      1. USuser2864740
    3. CO@user2864740: I am not retarded, I figured out that on my own. The question is what can I do to solve that issue.
      singulars
      1. POc# - importing xml file
      1. USExinta Enea
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload