Reading from xml file and writing to SQL-table

Question

Hi All

This sound very simple to but here goes..

I have a xml file that has multiple nodes with sub-nodes and need to take that info and write it to a SQL table. Using the SQLClient namespace would be the easiest to do a Insert Into the table once I have the data from the XML nodes.

How would it be possible for me to get a handle on those values in the xml file and manipulating them before I write them to a SQL table?

Thanks,