Exemple #1
0
        public void ExcelMappingTest()
        {
            //IMcOleDbHelper helper = (IMcOleDbHelper)Activator.GetObject(typeof(IMcOleDbHelper),
            //                                                    ConfigurationManager.AppSettings["McOleDbServiceString"]);

            //DataSet dataSet = helper.ConvertExcelToDataSet("price.xls");
            DataSet dataSet = ConvertExcelToDataSet("price.xls");

            MappingEngine mapEngine = new MappingEngine();

            mapEngine.MappingErrorEvent += ErrorHandler;

            MappingDocument mapDoc = MappingDocument.LoadFromFile("priceMapping.xml");

            mapEngine.ProcessMapping(mapDoc, dataSet);
        }
Exemple #2
0
        public void MappingDataTest()
        {
            DataSet dataSet = LoadDataSetfromXML("DataSet.xsd", "DataSet.xml");

            MappingEngine mapEngine = new MappingEngine();

            string mapFileName = @"BookMapping.xml";

            XmlDocument xmlDoc = new XmlDocument();

            xmlDoc.Load(mapFileName);

            MappingDocument mapDoc = MappingDocument.LoadFromXml(xmlDoc.OuterXml);

            mapEngine.ProcessMapping(mapDoc, dataSet);
        }