Gridview Export to XML not formatting tags correctly..
 

I have some code which exports the contents of a gridview to XML. The XML is coming out with incorrect field tags:

<tr>
<td>Builder Damage Inspection</td>
<td>request for final BDI inspection. No damage report on pre damage inspection.</td>
<td>2008-07-09 3:13:59 PM</td>
<td>2008-08-13 9:13:48 AM</td>
<td>512135</td>
<td>5450865</td>
<td>CLOSED</td>
</tr>

Here is the code I am using to do the export:

Response.ClearContent()

Response.AddHeader("content-disposition", "attachment; filename=test.xml")

Response.ContentType = "text/xml"

Dim oStringWriter As New IO.StringWriter()

Dim oHtmlTextWriter As New HtmlTextWriter(oStringWriter)

GridView1.RenderControl(oHtmlTextWriter)

Response.Write(oStringWriter.ToString)

Response.End()

Am I taking the correct approach with this?

Thanks in advance,

M

Re: Gridview Export to XML not formatting tags correctly..
 

What are you wanting then?

Are you wanting the data or gridview to be written?

Also you are using htmltextwriter, which is exporting html.

Re: Gridview Export to XML not formatting tags correctly..
 

Thanks for your reply. I would like the data, not the html. Do you have a suggestion on how to export the output of a SQL data source instead?

Re: Gridview Export to XML not formatting tags correctly..
 

Use the DataSet.WriteXml method.

Post the code you have where you set the datasource if you are having trouble still.