Hi here is the code
Dim ds As New DataSet
Dim strPath As String
Dim strMessage As String
Dim strSql As String
strSql = "SELECT NetworkID, RoadID,MeanDepth, x1,x2,y1,
y2,ColorCode" & _
" FROM RoadAnalysisMeanDepth Where NetworkID=" &
NetworkID & " Order BY MeanDepth"
Dim daExport As New OleDb.OleDbDataAdapter(strSql,
oConString.ConString)
daExport.Fill(ds, "Roads")
ds.WriteXml(Me.txtFilePathName.Text & "\MyData.xml")
But i want to add some elements to that docs
<?xml version="1.0" standalone="yes" ?>
- <NewDataSet>
<TITLE>... . . . .. .</TITLE>
<IMAGE>xxxxxxx.jpg</IMAGE>
<DESCRIPTION>. . . . . . .. . .. . . .</DESCRIPTION>
<NetworkID>1</NetworkID>
-
<Space_x0020_Syntax_x0020_Analysis_x0020_of_x0020_ liverpool_x0020_city_x0020_center>
<RoadID>36</RoadID>
<MeanDepth>4.03333333333333</MeanDepth>
<x1>365</x1>
<x2>486</x2>
<y1>296</y1>
<y2>336</y2>
<ColorCode>5</ColorCode>
</Space_x0020_Syntax_x0020_Analysis_x0020_of_x0020_l iverpool_x0020_city_x0020_center>
-
<Space_x0020_Syntax_x0020_Analysis_x0020_of_x0020_ liverpool_x0020_city_x0020_center>
<RoadID>70</RoadID>
<MeanDepth>4.03333333333333</MeanDepth>
<x1>486</x1>
<x2>365</x2>
<y1>336</y1>
<y2>296</y2>
<ColorCode>5</ColorCode>
</Space_x0020_Syntax_x0020_Analysis_x0020_of_x0020_l iverpool_x0020_city_x0020_center>
</NewDataSet>
i dont know how to add Title image and discription node to existing one
any one have idea please let me know thanks