How to write xml file from gridview data

See more:

VB

Hi Guys can you please help. I am trying to create an xml from the data in the GridView, below is the code that I have for populating the GridView

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load

       Dim dt As New DataTable()
       Dim strConnString As String = System.Configuration.ConfigurationManager.ConnectionStrings("ApplicationServices").ConnectionString
       Dim strQuery As String = "select * from Customer_Details"
       Dim cmd As New SqlCommand(strQuery)
       Dim con As New SqlConnection(strConnString)
       Dim sda As New SqlDataAdapter()
       cmd.CommandType = CommandType.Text
       cmd.Connection = con
       Try
           con.Open()
           sda.SelectCommand = cmd
           sda.Fill(dt)
           Me.GridView1.DataSource = dt
           Me.GridView1.DataBind()
       Catch ex As Exception
           Response.Write(ex.Message)
       Finally
           con.Close()
           sda.Dispose()
           con.Dispose()
           dt.Dispose()
       End Try

   End Sub