C#中Xml文件的读写问题

最新推荐文章于 2021-08-13 15:24:58 发布

zhensoft163

最新推荐文章于 2021-08-13 15:24:58 发布

阅读量1k

点赞数

分类专栏：专业技能文章标签： xml c# string exception 文档数据库

本文链接：https://blog.youkuaiyun.com/zhensoft163/article/details/4069406

版权

专业技能专栏收录该内容

48 篇文章

订阅专栏

本文介绍了一种将数据库数据导出至XML文件的简便方法。起初作者使用了繁琐的方式逐条记录XML文件，后来发现只需两行代码即可通过DataTable对象直接将数据写入XML文件，极大地提高了效率。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

前两天做了一个小接口，是将数据库数据保存到xml中，然后在将xml中的数据导入到另外一个数据库中。

一开始稀里糊涂写了一番。

写入xml：

//初始化XML文档操作类 XmlDocument myXml = new XmlDocument(); /// <summary> /// 保存数据到Xml文件中 /// </summary> /// <returns>cardInfo</returns> public void CardInfoSave(string beginTime,string endTime) { //生成xml文件的头文件 XmlNode xmlnode = myXml.CreateNode(XmlNodeType.XmlDeclaration,"", ""); myXml.AppendChild(xmlnode); //加入一个根元素 XmlElement xmlelem = myXml.CreateElement("", "Card", ""); XmlText xmltext = myXml.CreateTextNode(""); xmlelem.AppendChild(xmltext); myXml.AppendChild(xmlelem); //写入到Xml文件中 string FileName = System.IO.Path.Combine(AppSettings.GetValue("Url"), AppSettings.GetValue("Store") + DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() + "//CardInfo.xml"); DataTable dt = DbHelperSQL.Instance.GetDataTable(sqlGetCardInfo + " where lossDate >='" + beginTime + "' and lossDate<= '" + endTime + "'"); if (dt != null && dt.Rows.Count != 0) { for (int i = 0; i < dt.Rows.Count; i++) { #region 设置对象的值 cardinfoModel.CardNo = dt.Rows[i]["CardNo"].ToString(); cardinfoModel.CardOutNo = dt.Rows[i]["CardOutNo"].ToString(); cardinfoModel.IsVip = dt.Rows[i]["IsVip"].ToString(); cardinfoModel.Password = dt.Rows[i]["Password"].ToString(); cardinfoModel.Deposit = Utilities.ConvertDeciamal(dt.Rows[i]["Deposit"]); cardinfoModel.MakeCardDate = Convert.ToDateTime(dt.Rows[i]["MakeCardDate"]); cardinfoModel.MakeCardOperator = dt.Rows[i]["MakeCardOperator"].ToString(); cardinfoModel.SalesDate = Convert.ToDateTime(dt.Rows[i]["SalesDate"]); cardinfoModel.RejectCardDate = Convert.ToDateTime(dt.Rows[i]["RejectCardDate"]); cardinfoModel.CosumeExpireDate = Convert.ToDateTime(dt.Rows[i]["CosumeExpireDate"]); cardinfoModel.ExpireDate = Convert.ToDateTime(dt.Rows[i]["ExpireDate"]); cardinfoModel.LossDate = Convert.ToDateTime(dt.Rows[i]["LossDate"]); cardinfoModel.ReceiveMoneyTotal = Utilities.ConvertDeciamal(dt.Rows[i]["ReceiveMoneyTotal"]); cardinfoModel.RechargeableTotal = Utilities.ConvertDeciamal(dt.Rows[i]["RechargeableTotal"]); cardinfoModel.RechareeableCount = Convert.ToInt32(dt.Rows[i]["RechareeableCount"]); cardinfoModel.PayTotal = Utilities.ConvertDeciamal(dt.Rows[i]["PayTotal"]); cardinfoModel.PayCount = Utilities.ConvertInt(dt.Rows[i]["PayCount"].ToString()); cardinfoModel.Balance = Utilities.ConvertDeciamal(dt.Rows[i]["Balance"]); cardinfoModel.UseBalance = Utilities.ConvertDeciamal(dt.Rows[i]["UseBalance"]); cardinfoModel.Operator = dt.Rows[i]["Operator"].ToString(); cardinfoModel.IsIntegrate = dt.Rows[i]["IsIntegrate"].ToString(); cardinfoModel.IntegrationValue = Utilities.ConvertDeciamal(dt.Rows[i]["IntegrationValue"]); cardinfoModel.State = dt.Rows[i]["State"].ToString(); cardinfoModel.CustomerName = dt.Rows[i]["CustomerName"].ToString(); cardinfoModel.Sex = dt.Rows[i]["Sex"].ToString(); cardinfoModel.CustomerType = dt.Rows[i]["CustomerType"].ToString(); cardinfoModel.IdType = dt.Rows[i]["IdType"].ToString(); cardinfoModel.TelNo = dt.Rows[i]["TelNo"].ToString(); cardinfoModel.Address = dt.Rows[i]["Address"].ToString(); cardinfoModel.IdNo = dt.Rows[i]["IdNo"].ToString(); cardinfoModel.BirthDate = Convert.ToDateTime(dt.Rows[i]["BirthDate"]); cardinfoModel.MobileNo = dt.Rows[i]["MobileNo"].ToString(); cardinfoModel.CompanyName = dt.Rows[i]["CompanyName"].ToString(); cardinfoModel.BirthPlace = dt.Rows[i]["BirthPlace"].ToString(); cardinfoModel.Hobbies = dt.Rows[i]["Hobbies"].ToString(); cardinfoModel.PositionName = dt.Rows[i]["PositionName"].ToString(); cardinfoModel.SpecialInfo = dt.Rows[i]["SpecialInfo"].ToString(); cardinfoModel.Memo = dt.Rows[i]["Memo"].ToString(); cardinfoModel.CustomerCode = dt.Rows[i]["CustomerCode"].ToString(); #endregion try { this.WriteXml(FileName, cardinfoModel);//添加子节点 } catch (Exception ex) { throw ex; } } } else { this.WriteXml(FileName); } } /// <summary> /// 将数据写入Xml文件 /// </summary> /// <param name="FileName">要写入的Xml文件</param> /// <param name="model">卡的信息</param> public void WriteXml(string FileName, CardInfoModel model) { 初始化XML文档操作类 //XmlDocument myXml = new XmlDocument(); #region 为节点添加元素 //添加元素 XmlElement ele0 = myXml.CreateElement("CardNo"); XmlText Text0 = myXml.CreateTextNode(model.CardNo); XmlElement ele1 = myXml.CreateElement("CardOutNo"); XmlText Text1 = myXml.CreateTextNode(model.CardOutNo); XmlElement ele2 = myXml.CreateElement("IsVip"); XmlText Text2 = myXml.CreateTextNode(model.IsVip); XmlElement ele3 = myXml.CreateElement("Password"); XmlText Text3 = myXml.CreateTextNode(model.Password); XmlElement ele4 = myXml.CreateElement("Deposit"); XmlText Text4 = myXml.CreateTextNode(model.Deposit.ToString()); XmlElement ele5 = myXml.CreateElement("MakeCardDate"); XmlText Text5 = myXml.CreateTextNode(model.MakeCardDate.ToString()); XmlElement ele6 = myXml.CreateElement("MakeCardOperator"); XmlText Text6 = myXml.CreateTextNode(model.MakeCardOperator); XmlElement ele7 = myXml.CreateElement("SalesDate"); XmlText Text7 = myXml.CreateTextNode(model.SalesDate.ToString()); XmlElement ele8 = myXml.CreateElement("RejectCardDate"); XmlText Text8 = myXml.CreateTextNode(model.RejectCardDate.ToString()); XmlElement ele9 = myXml.CreateElement("CosumeExpireDate"); XmlText Text9 = myXml.CreateTextNode(model.CosumeExpireDate.ToString()); XmlElement ele10 = myXml.CreateElement("ExpireDate"); XmlText Text10 = myXml.CreateTextNode(model.ExpireDate.ToString()); XmlElement ele11 = myXml.CreateElement("LossDate"); XmlText Text11 = myXml.CreateTextNode(model.LossDate.ToString()); XmlElement ele12 = myXml.CreateElement("RechargeableTotal"); XmlText Text12 = myXml.CreateTextNode(model.RechargeableTotal.ToString()); XmlElement ele13 = myXml.CreateElement("ReceiveMoneyTotal"); XmlText Text13 = myXml.CreateTextNode(model.ReceiveMoneyTotal.ToString()); XmlElement ele14 = myXml.CreateElement("RechareeableCount"); XmlText Text14 = myXml.CreateTextNode(model.RechareeableCount.ToString()); XmlElement ele15 = myXml.CreateElement("PayTotal"); XmlText Text15 = myXml.CreateTextNode(model.PayTotal.ToString()); XmlElement ele16 = myXml.CreateElement("PayCount"); XmlText Text16 = myXml.CreateTextNode(model.PayCount.ToString()); XmlElement ele17 = myXml.CreateElement("Balance"); XmlText Text17 = myXml.CreateTextNode(model.Balance.ToString()); XmlElement ele18 = myXml.CreateElement("UseBalance"); XmlText Text18 = myXml.CreateTextNode(model.UseBalance.ToString()); XmlElement ele19 = myXml.CreateElement("Operator"); XmlText Text19 = myXml.CreateTextNode(model.Operator); XmlElement ele20 = myXml.CreateElement("IsIntegrate"); XmlText Text20 = myXml.CreateTextNode(model.IsIntegrate); XmlElement ele21 = myXml.CreateElement("IntegrationValue"); XmlText Text21 = myXml.CreateTextNode(model.IntegrationValue.ToString()); XmlElement ele22 = myXml.CreateElement("State"); XmlText Text22 = myXml.CreateTextNode(model.State); XmlElement ele23 = myXml.CreateElement("CustomerName"); XmlText Text23 = myXml.CreateTextNode(model.CustomerName); XmlElement ele24 = myXml.CreateElement("Sex"); XmlText Text24 = myXml.CreateTextNode(model.Sex); XmlElement ele25 = myXml.CreateElement("CustomerType"); XmlText Text25 = myXml.CreateTextNode(model.CustomerType); XmlElement ele26 = myXml.CreateElement("IdType"); XmlText Text26 = myXml.CreateTextNode(model.IdType); XmlElement ele27 = myXml.CreateElement("TelNo"); XmlText Text27 = myXml.CreateTextNode(model.TelNo); XmlElement ele28 = myXml.CreateElement("Address"); XmlText Text28 = myXml.CreateTextNode(model.Address); XmlElement ele29 = myXml.CreateElement("IdNo"); XmlText Text29 = myXml.CreateTextNode(model.IdNo); XmlElement ele30 = myXml.CreateElement("BirthDate"); XmlText Text30 = myXml.CreateTextNode(model.BirthDate.ToString()); XmlElement ele31 = myXml.CreateElement("MobileNo"); XmlText Text31 = myXml.CreateTextNode(model.MobileNo); XmlElement ele32 = myXml.CreateElement("CompanyName"); XmlText Text32 = myXml.CreateTextNode(model.CompanyName); XmlElement ele33 = myXml.CreateElement("BirthPlace"); XmlText Text33 = myXml.CreateTextNode(model.BirthPlace); XmlElement ele34 = myXml.CreateElement("Hobbies"); XmlText Text34 = myXml.CreateTextNode(model.Hobbies); XmlElement ele35 = myXml.CreateElement("PositionName"); XmlText Text35 = myXml.CreateTextNode(model.PositionName); XmlElement ele36 = myXml.CreateElement("SpecialInfo"); XmlText Text36 = myXml.CreateTextNode(model.SpecialInfo); XmlElement ele37 = myXml.CreateElement("Memo"); XmlText Text37 = myXml.CreateTextNode(model.Memo); XmlElement ele38 = myXml.CreateElement("CustomerCode"); XmlText Text38 = myXml.CreateTextNode(model.CustomerCode); //添加元素的节点---CardInfo XmlNode newElem = myXml.CreateNode("element", "CardInfo", ""); //在节点中添加元素 newElem.AppendChild(ele0); newElem.LastChild.AppendChild(Text0); newElem.AppendChild(ele1); newElem.LastChild.AppendChild(Text1); newElem.AppendChild(ele2); newElem.LastChild.AppendChild(Text2); newElem.AppendChild(ele3); newElem.LastChild.AppendChild(Text3); newElem.AppendChild(ele4); newElem.LastChild.AppendChild(Text4); newElem.AppendChild(ele5); newElem.LastChild.AppendChild(Text5); newElem.AppendChild(ele6); newElem.LastChild.AppendChild(Text6); newElem.AppendChild(ele7); newElem.LastChild.AppendChild(Text7); newElem.AppendChild(ele8); newElem.LastChild.AppendChild(Text8); newElem.AppendChild(ele9); newElem.LastChild.AppendChild(Text9); newElem.AppendChild(ele10); newElem.LastChild.AppendChild(Text10); newElem.AppendChild(ele11); newElem.LastChild.AppendChild(Text11); newElem.AppendChild(ele12); newElem.LastChild.AppendChild(Text12); newElem.AppendChild(ele13); newElem.LastChild.AppendChild(Text13); newElem.AppendChild(ele14); newElem.LastChild.AppendChild(Text14); newElem.AppendChild(ele15); newElem.LastChild.AppendChild(Text15); newElem.AppendChild(ele16); newElem.LastChild.AppendChild(Text16); newElem.AppendChild(ele17); newElem.LastChild.AppendChild(Text17); newElem.AppendChild(ele18); newElem.LastChild.AppendChild(Text18); newElem.AppendChild(ele19); newElem.LastChild.AppendChild(Text19); newElem.AppendChild(ele20); newElem.LastChild.AppendChild(Text20); newElem.AppendChild(ele21); newElem.LastChild.AppendChild(Text21); newElem.AppendChild(ele22); newElem.LastChild.AppendChild(Text22); newElem.AppendChild(ele23); newElem.LastChild.AppendChild(Text23); newElem.AppendChild(ele24); newElem.LastChild.AppendChild(Text24); newElem.AppendChild(ele25); newElem.LastChild.AppendChild(Text25); newElem.AppendChild(ele26); newElem.LastChild.AppendChild(Text26); newElem.AppendChild(ele27); newElem.LastChild.AppendChild(Text27); newElem.AppendChild(ele28); newElem.LastChild.AppendChild(Text28); newElem.AppendChild(ele29); newElem.LastChild.AppendChild(Text29); newElem.AppendChild(ele30); newElem.LastChild.AppendChild(Text30); newElem.AppendChild(ele31); newElem.LastChild.AppendChild(Text31); newElem.AppendChild(ele32); newElem.LastChild.AppendChild(Text32); newElem.AppendChild(ele33); newElem.LastChild.AppendChild(Text33); newElem.AppendChild(ele34); newElem.LastChild.AppendChild(Text34); newElem.AppendChild(ele35); newElem.LastChild.AppendChild(Text35); newElem.AppendChild(ele36); newElem.LastChild.AppendChild(Text36); newElem.AppendChild(ele37); newElem.LastChild.AppendChild(Text37); newElem.AppendChild(ele38); newElem.LastChild.AppendChild(Text38); //将节点添加到文档中 XmlElement root = myXml.DocumentElement; root.AppendChild(newElem); #endregion //保存所有的修改 myXml.Save(FileName); } /// <summary> /// 如果没有数据则只保存根目录 /// </summary> /// <param name="FileName"></param> public void WriteXml(string FileName) { myXml.Save(FileName); }

超级麻烦的方法，字段越多越麻烦。

不过没办法为了完成任务也只有这样了啊。不过今天看到另一种方法我差点晕过去。

DataTable dt = new DataTable("CardInfo");

dt.WriteXml("D://a.xml");

两行代码完事。

我晕死啊！