ds.WriteXml change predifined NewDataSet (name) and Table (name) to something custum

Question

User1444011213 posted

Hi, 

I have written a script in VB that takes date from sql query and stores it in xml file, but I need to change default names of main threat

This is what I am currently get as an resoult:

<?xml version="1.0" standalone="yes"?>
  <NewDataSet>
    <Table>
      <Code>2581</Code>
      <Name>Name1</Name>
      <Price>58.85</Price>
    </Table>
    <Table>
      <Code>2607</Code>
      <Name>Name2</Name>
      <Price>452.44</Price>
    </Table>
</NewDataSet>

I need to change this:

<Table></Table> to say <kolona></kolona>

<NewDataSet></NewDataSet> to say <pocetak></pocetak>

so the end resolut should be:

<?xml version="1.0" standalone="yes"?>
  <pocetak>
    <kolona>
      <Code>2581</Code>
      <Name>Name1</Name>
      <Price>58.85</Price>
    </kolona>
    <kolona>
      <Code>2607</Code>
      <Name>Name2</Name>
      <Price>452.44</Price>
    </kolona>
</pocetak>

I am using this command:

adapter = New SqlDataAdapter(selectSQL, connectionString)
adapter.Fill(ds)
ds.WriteXml(Path.Combine(Request.PhysicalApplicationPath, "\test.xml"), Data.XmlWriteMode.IgnoreSchema)

Thanks for any help

Answer 1

User1444011213 posted

Hi,

I managed to set diferent name for root <NewDataSet> with command

        Dim ds = New DataSet("pocetak")

So now I am geting:

<?xml version="1.0" standalone="yes"?>
  <pocetak>
    <Table>
      <Code>2581</Code>
      <Name>Name1</Name>
      <Price>58.85</Price>
    </Table>
    <Table>
      <Code>2607</Code>
      <Name>Name2</Name>
      <Price>452.44</Price>
    </Table>
</pocetak>

It still remains how can I change nod name <Table> to <kolona>...

Any idea?

Thx

Answer 2

User1724605321 posted

Hi ,

You could change the  name of the DataTable before you write it out:

http://stackoverflow.com/questions/28290205/creating-xml-using-dataset-writexml-how-to-change-the-node-name 

Or not use WriteXml function , you could create your own xml file like :

http://www.dotnetperls.com/xmlwriter-vbnet 

http://vb.net-informations.com/xml/create-xml-vb.net.htm 

Best Regards,

Nan Yu