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

What are you wanting then?

Are you wanting the data or gridview to be written?

Also you are using htmltextwriter, which is exporting html.

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?

Use the DataSet.WriteXml method.

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

This article has been dead for over six months. Start a new discussion instead.