Windows Form Application

Question

I have a one xml file data. How to read and write the data in Windows application and how to save the SQL Databasse

Mahesh Chand · Answer

You can read XML and then write to the database. You will have to figure out what XML tag needs to map with a table column. Start with this: http://www.c-sharpcorner.com/UploadFile/167ad2/read-xml-file-using-xml-reader-in-C-Sharp/

Hamid Khan · Answer

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; } _________________________________