如何使用数据集更新XML数据 [英] How to update the data of XML using dataset

问题描述

我使用数据集将数据写入XML文件，如下所示

i use dataset to write data to XML file as shown bellow

 private void CreateDataset()
    {
        try
        {
            int BusId = 0;
            int UserID = Convert.ToInt32(Session["UserId"]);
            DataSet Ds = objsalesTaxBAl.GetBusID("MS", OrgId, DdlDealerName.SelectedValue);
            if (Ds != null)
            {
                if (Ds.Tables[0].Rows.Count > 0)
                {
                    BusId = Convert.ToInt32(Ds.Tables[0].Rows[0]["BUSINESS_ID"].ToString());
                }
            }
            DataSet ds = new DataSet();
            DataTable dt = new DataTable();
            dt.Columns.Add("UserId");
            dt.Columns.Add("BusID");
            dt.Columns.Add("FY");
            dt.Columns.Add("RetType");
            dt.Columns.Add("NatRet");
            dt.Columns.Add("Period");
            DataRow dr = dt.NewRow();
            dr["UserId"] = UserID;
            dr["BusId"] = BusId;
            dr["FY"] = Convert.ToString(DdlFY.SelectedValue);
            dr["RetType"] = Convert.ToString(DdlRetType.SelectedValue);
            dr["NatRet"] = Convert.ToString(DdlNatRet.SelectedValue);
            dr["Period"] = Convert.ToString(DdlPeriod.SelectedValue);
            dt.Rows.Add(dr);
            ds.Tables.Add(dt);
            ds.AcceptChanges();
            ds.WriteXml(HttpContext.Current.Server.MapPath("~/") + "\\App_Data\\VAT.xml");
            SaveDataToXML(UserID, BusId, FY, RetType, NatRet, Period);
        }
        catch
        {
        }
    }
<pre lang="cs">private void SaveDataToXML(int UserID, int BusId, string FY, string RetType, string NatRet, string Period)
   {
       try
       {
           DataSet dsDetails = new DataSet();
           dsDetails.ReadXml(HttpContext.Current.Server.MapPath("~/") + "\\App_Data\\VAT.xml");

           dsDetails.Tables[0].Rows[0]["UserId"] = ObjUFP.EncryptString(Convert.ToString(UserID));
           dsDetails.Tables[0].Rows[0]["BusId"] = ObjUFP.EncryptString(Convert.ToString(BusId));
           dsDetails.Tables[0].Rows[0]["FY"] = ObjUFP.EncryptString(FY);
           dsDetails.Tables[0].Rows[0]["RetType"] = ObjUFP.EncryptString(RetType);
           dsDetails.Tables[0].Rows[0]["NatRet"] = ObjUFP.EncryptString(NatRet);
           dsDetails.Tables[0].Rows[0]["Period"] = ObjUFP.EncryptString(Period);

           dsDetails.WriteXml(HttpContext.Current.Server.MapPath("~/") + "\\App_Data\\VAT.xml");
       }
       catch
       {
       }
   }

现在，如果XML文件中已经存在userId，我想更新XML文件数据.

Now i want to update the XML file data if userId is already present in XML file.
how can i?

推荐答案

myDataSet.WriteXml("myxmlfile.xml", XmlWriteMode.IgnoreSchema);

这篇关于如何使用数据集更新XML数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！