C# 读取xml文件

private void XMLToDB_Click(object sender, EventArgs e)
{
string BoeProductPath =@"e:\ew\BoeProductV2.xml";

        XmlTextReader reader = new XmlTextReader(BoeProductPath);
        List<FSProductModel> modelList = new List<FSProductModel>();
        FSProductModel model = new FSProductModel();
        while (reader.Read())
        {
            if (reader.NodeType == XmlNodeType.Element)
            {
                if (reader.Name == "ProductNo")
                {
                    model.ProductNo = reader.ReadElementString().Trim();
                }
                if (reader.Name == "ProdName")
                {
                    model.ProdName = reader.ReadElementString().Trim();
                }
                if (reader.Name == "ProdClass")
                {
                    model.ProdClass = reader.ReadElementString().Trim();
                }
                if (reader.Name == "ProdLimit")
                {
                    model.ProdLimit = reader.ReadElementString().Trim();
                }
                if (reader.Name == "ProdProfit")
                {
                    model.ProdProfit = reader.ReadElementString().Trim();
                }
                if (reader.Name == "ProdYildType")
                {
                    model.ProdYildType = reader.ReadElementString().Trim();
                }
                if (reader.Name == "ProdArea")
                {
                    model.ProdArea = reader.ReadElementString().Trim();
                }
                if (reader.Name == "ProdSaleDate")
                {
                    model.ProdSaleDate = reader.ReadElementString().Trim();
                }
                if (reader.Name == "IsCanBuy")
                {
                    model.IsCanBuy = reader.ReadElementString().Trim();
                }
                if (reader.Name == "PurStarAmo")
                {
                    model.PurStarAmo = reader.ReadElementString().Trim();
                }
                

            }
            if (reader.NodeType == XmlNodeType.EndElement)
            {
                if (reader.Name == "RowNumber")
                {
                    modelList.Add(model);
                    model = new FSProductModel();
                }
            }
        }

        modelList.RemoveAt(modelList.Count - 1);

        this.dgvList.DataSource = modelList;
    }

    private void showInfoByElements(IEnumerable<XElement> elements)
    {
        List<FSProductModel> modelList = new List<FSProductModel>();
        foreach (var ele in elements)
        {
            FSProductModel model = new FSProductModel();

            model.ProductNo = ele.Element("ProductNo").Value;
            model.ProdName = ele.Element("ProdName").Value;
            model.ProdClass = ele.Element("ProdClass").Value;
            model.ProdSaleDate = ele.Element("ProdSaleDate").Value;
            model.ProdLimit = ele.Element("ProdLimit").Value;
            model.ProdProfit = ele.Element("ProdProfit").Value;
            model.ProdYildType = ele.Element("ProdYildType").Value;
            model.PurStarAmo = ele.Element("PurStarAmo").Value;
            model.ProdArea = ele.Element("ProdArea").Value;
            model.IsCanBuy = ele.Element("IsCanBuy").Value;
            modelList.Add(model);
        }
        dgvList.DataSource = modelList;
    }
posted @ 2015-06-19 22:47  peixin  阅读(154)  评论(0)    收藏  举报