Vb.net save xml file to database

->>>> Click Here to Download <<<<<<<-

Ask a question. Quick access. Search related threads. Remove From My Forums. Answered by:. Archived Forums. Sign in to vote. Hello, I have just about given up on my aim to learn how to save data from listbox to xml and then retreive them in vb. I have tried everything all the forms to millions of google searches yet I havent found an answer please if someone here would be able to answer it.

I am sure it is not that hard. The setup of my application isthe following. I have a text box and a listbox, when a button is pressed everything from the textbox is displayed into the listbox.

Now I want this to happen when I press anoter button on the for, everything which is in the listbox saves. The same happens if I close the application. Lastly I want the data to be loded back when the application is restarted. I have tried everything from my. Monday, February 2, PM. Add xn. CreateElement "value" xn.

AppendChild xn Next doc. AppendChild root doc. Save fileName End Sub. Use the Items-Collection of your ListBox to retreive all items within the Click event handler of your second button. Using the items you can, for example, create an XML file.

There are readers available to read your file into a collection. Descendants "value" select p. Value; StringsListBox. Clear ; StringsListBox. Items select new XElement "value" , p ; doc. Add root ; doc. Oh sorry, I haven't seen that you need this for VB. I mean imports yes. I hope that works. Value StringsListBox. Clear StringsListBox. Add root doc. Thanks for the reply. You see I am a begginer and I have refered to this documentation form MSDN and it is very very hard to learn that, I have tried that but I have failed.

What I was looking for is someone to give me the code so I can understand how it works and learn from it. This code has laods of erros declaration errors and more could you please clarify on how to fully declare and use thic code if possible the following errors are: Error 1 Name 'XDocument' is not declared.

Error 2 Method arguments must be enclosed in parentheses. White space is preserved only if PreserveWhitespace is set to true. The XmlDeclaration of the current XmlDocument object determines the encoding attribute in the saved document. The value of the encoding attribute is taken from the XmlDeclaration.

Encoding property. If the XmlDocument does not have an XmlDeclaration, or if the XmlDeclaration does not have an encoding attribute, the saved document will not have one either. For example, the following C code. Note that only the Save method enforces a well-formed XML document.

All other Save overloads only guarantee a well-formed fragment. The encoding on the TextWriter determines the encoding that is written out The encoding of the XmlDeclaration node is replaced by the encoding of the TextWriter.

If there was no encoding specified on the TextWriter , the XmlDocument is saved without an encoding attribute. The following example loads XML into an XmlDocument object, modifies it, and then saves it to a file named data.

The data. White space is preserved in the output file only if PreserveWhitespace is set to true. ReadStartElement "name" txtName. ReadString reader.

ReadStartElement "color" txtColor. ReadStartElement "number" txtNumber. ReadStartElement "zipcode" txtZipCode. ReadEndElement End If reader. Show "There was an error retrieving the data! Message Finally reader.

Object, e As System. EventArgs Handles btnSave. EventArgs Handles btnClear. Click txtName. EventArgs Handles btnRetrieve. Cody Cody 59 2 2 silver badges 11 11 bronze badges. Add a comment. Active Oldest Votes. Root txtName. Element "name". Value txtColor. Element "color". Value txtNumber. Element "number". Value txtZipCode. Element "zipcode". Value End With As your XML structure becomes more complicated, the approach you've taken would become a maintenance nightmare.

Neolisk Neolisk Thank for the elegance of your answer! I appreciate the example as well as study-support orientation. Like I have mentioned before, I have been working with vb. I would vote this answer up, but I lack the ability Cody: You are welcome! Should be able to upvote at 15 reputation, and you are almost there! ReadStartElement "name" If Not reader.

IsEmptyElement Then txtName. ReadString End If reader. ReadEndElement reader. ReadStartElement "color" If Not reader. IsEmptyElement Then txtColor. ReadStartElement "number" If Not reader.