Want to read data from XML file and export this data into the data set

[alwayssmiling]

HI,

I want to read data from xml file and export this data to dataset. I know abt the basics of opening a file using application, workbook and worksheet classes. But i don't know how to read data from the xml class to populate it into the database. I think i have to use the class Range. Can any one explain how to do it ?????????????



Thank You

[digitalmanic]

string myXMLfile = "C:\\MySchema.xml";
DataSet ds = new DataSet();
try
{
ds.ReadXml(myXMLfile);
dataGrid1.DataSource = ds;
dataGrid1.DataMember = "Cust";
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}


Please check the following link for more details.

http://support.microsoft.com/kb/311566

[alwayssmiling]

hi sorry for this that is not xml file its an "excel file" plz note it