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

浙公网安备 33010602011771号