I am using vb.net and i want to create an xml file with an output similar to this: (the information in red comes from a table in SQLServer2000)
<partinformation>
  <header>
    <extractversion>1.1.2</extractversion>
    <Parentinformation>
        <Duns>12346</Duns>
        <Location>01</Location>
    </Parentinformation>
    <ManufacturerInformation>
      <Duns>54646</Duns>
      <Location>01</Location>
    </ManufacturerInformation>
  </header>
</partinformation>

Ok- is there a question in there somewhere?


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

I am using vb.net and i want to create an xml file with an output similar to this: (the information in red comes from a table in SQLServer2000) How do i do this?
<partinformation>
  <header>
    <extractversion>1.1.2</extractversion>
    <Parentinformation>
        <Duns>12346</Duns>
        <Location>01</Location>
    </Parentinformation>
    <ManufacturerInformation>
      <Duns>54646</Duns>
      <Location>01</Location>
    </ManufacturerInformation>
  </header>
</partinformation>

Ok- well, you open a file you write out the data and then you close the file.

I'm not going to write the routine for you- so if you have some specific questions, I'll be happy to answer what I can.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

My table consists of the fields "ParentDuns", "ParentLocation", "ManufacturerDuns" & "ManufacturerLocation", so if were to write a sql with the keywords "FOR XML AUTO" or "FOR XML AUTO, ELEMENTS" i do not get the required output format. Do i am thinking that i need to modify the output of my sql, but i don't know how? I know how to read the data from a table in vb.net, but how i read the data from the table and write it out in the xml format given below?

You can't. SQL outputs it in the form it has specified and you can't really change it- as far as I know.. You would need to ask in the SQL forum.

I'd read the data into a dataset and then write out the file in the format I want.
You can also use XSLT to convert the XML out of SQL to the format you want..

That said, since I am no XML or XSL expert, I'd write a program.


Hal Levy
Web Developer, PDI Inc.

NOT a Wiley/Wrox Employee

hi friend,
I thought you might get the partial solution to your problem
I dataset of Vb.NET there is method of save in which u specify
the XML as its output but the XML generated in which it gives the
complete listing the of fields and associated attribute as well
as the data you are desire as the requirement is of fields name
should be of same name as like the element name
i have tried in VB with ADO 2.8, the recordset method save in which u have
to specify persistformat

<partinformation>
  <header>
    <extractversion>1.1.2</extractversion>
    <Parentinformation>
        <Duns>12346</Duns>
        <Location>01</Location>
    </Parentinformation>
    <ManufacturerInformation>
      <Duns>54646</Duns>
      <Location>01</Location>
    </ManufacturerInformation>
  </header>
</partinformation>

Thanks

Sunil