Windows Form Application

Read File data :
private FileDataModel ReadXmlFile(FileImportCriteriaModel fileImportCriteriah)
{
try
{
//get your file
var xele = XElement.Load(fileImportCriteriah.FilePath);
// declare a new DataTable and pass your XElement to it
var dataTable1 = XElementToDataTable(xele);
// Convert From Table To Object
var fileDataModel = ConvertFromTableToObject(dataTable1);
return fileDataModel;
}
catch (XmlException)
{
throw new PersistenceValidationException("Validation Error",
new List
{
new BrokenRule("InvalidXml", "Invalid Xml file.")
});
}
}
private static DataTable XElementToDataTable(XElement x)
{
var dtable = new DataTable();
var setup = (from p in x.Descendants() select p).First();
// build your DataTable
foreach (var xe in setup.Descendants())
dtable.Columns.Add(new DataColumn(xe.Name.ToString(), typeof (string))); // add columns to your dt
var all = from p in x.Descendants(setup.Name.ToString()) select p;
foreach (var xe in all)
{
var dr = dtable.NewRow();
foreach (var xe2 in xe.Descendants())
dr[xe2.Name.ToString()] = xe2.Value; //add in the values
dtable.Rows.Add(dr);
}
return dtable;
}
_________________________________

2 Replies

Know the answer? Post it — somebody with the same question will find it here.