import export xml

Question

Hello

Using Access database engine and OleDbDataReader I need to open a table, read all columns of a single row and save the data in xml, or import back to the database.

Using MyConnection As New OleDbConnection(dbstring)
MyConnection.Open()
Using ReadUsers As New OleDbCommand("SELECT * FROM tableName WHERE columnField = 'blah'", MyConnection)
Using MyReaders As OleDbDataReader = ReadUsers.ExecuteReader
MyReaders.Read()
Using MyWriter As New XmlTextWriter(SFD.FileName, Encoding.UTF8)
MyWriter.WriteStartDocument(True)
MyWriter.Formatting = Formatting.Indented
MyWriter.Indentation = 2
MyWriter.WriteStartElement(Field) / MyWriter.WriteString(Value) / MyWriter.WriteEndElement()

It works but when reading it back, XmlTextReader will not work as expected

Using MyReader As New XmlTextReader(OFD.FileName)
While MyReader.Read
MyReader.ReadStartElement(Field) / MyReader.ReadString() / MyReader.ReadEndElement()

I found that it's forward-only, so a waste of time, anyone can suggest which class to use in .net framework 4.0?

Answer 1

Hi @StewartBW ,

You can consider using the DataSet class's ReadXml and WriteXml methods.

You can serialize the data from the database into XML using the WriteXml method of the DataSet class, and then deserialize it back into a DataSet using the ReadXml method.

Best Regards.

Jiachen Li

---

If the answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.