xml to datatable...

[rajesh.forum]

Hi!!!!
How to convert xml content to a datatable...I need to display the converted datatable to a datagridview...



regards,
rajesh...

 

[JohnH]

Thread moved to VB.Net Data Access forum.

Check Dataset/DataTable members in documentation, there is a ReadXml method or similar.

 

[cjard]

Hi!!!!
How to convert xml content to a datatable...I need to display the converted datatable to a datagridview...



regards,
rajesh...

Depends on the xml file. It is likely that:

Dim ds as New DataSet
ds.ReadXml("path to xml file")
will give you a dataset with more than one datatable in.

put a breakpoint on the line after the readxml call
run the code
highlight the dataset and point to it
in the tooltip that appears, click the magnifying glass icon to launch the dataset viewer.

amazing thing that is