How to convert XML document data in SQL DataTable in C#

Question

Could someone please provide me with an example on how to convert an XML document into SQL DataTable please using C#. Thanks

Mahesh Chand · Answer

You can use DataSet.ReadXml method to load an XML document to a DataSet. DataSet.Tables will give you all DataTables in the DataSet. If you have only one DataTable you can access using this: DataTable table = DataSet.Tables[0]; Read this document to learn more about DataSet.ReadXml method: http://msdn.microsoft.com/en-us/library/aa325639(VS.71).aspx