how to remove xml node diffgr:id="OpportunityElement1" msdata:rowOrder="0" using C#[Answered] RSS

• • Reply
  micnie2020

  Member

  124 Points

  786 Posts

  how to remove xml node diffgr:id="OpportunityElement1" msdata:rowOrder="0" using C#

  Apr 04, 2013 10:37 AM|micnie2020|LINK

  Hi All,

   

  I have xml node as below:

   

  <OpportunityElement diffgr:id="OpportunityElement1" msdata:rowOrder="0">
  :
  :
  <OpportunityElement diffgr:id="OpportunityElement2" msdata:rowOrder="1">
  :
  :

   

  My C# code as:-

  StreamReader streamReader = new StreamReader(@"" + file1);
                  StreamWriter streamWriter = new StreamWriter(@"" + file1.Replace(".xml", "_1.xml"));
  
  
  
                  while (!streamReader.EndOfStream)
                  {
                      string data = streamReader.ReadLine();
                      //data = data.Replace("DataSet1", "DataSet1 xmlns:msdata=\"http://diffgr\" xmlns:diffgr=\"http://diffgr\"");
                      data = data.Replace(" xmlns=\"http://tempuri.org/DataSet1.xsd\"", "").Replace("<diffgr:diffgram xmlns:msdata=\"urn:schemas-microsoft-com:xml-msdata\" xmlns:diffgr=\"urn:schemas-microsoft-com:xml-diffgram-v1\">", "").Replace("</diffgr:diffgram>", "").Replace("diffgr:", "").Replace(" diffgr:", "").Replace("msdata:", "");
                      streamWriter.WriteLine(data);
  
                  }
  
                  streamReader.Close();
                  streamWriter.Close();

  But, how i can i remove
  <OpportunityElement diffgr:id="OpportunityElement1" msdata:rowOrder="0">
  :
  :
  <OpportunityElement diffgr:id="OpportunityElement2" msdata:rowOrder="1">
  :
  :

   

   

  Please Advise.

   

  Thank You.

   

  Regards,

  Micheale

• • Reply
  ramanselva

  Participant

  1414 Points

  315 Posts

  Re: how to remove xml node diffgr:id="OpportunityElement1" msdata:rowOrder="0" using C#

  Apr 04, 2013 01:27 PM|ramanselva|LINK

  Hi,

             If you are populating the xml from dataset then try to call [datasetObject].AcceptChanges();

  method then diffgram elements will be removed.

  Please remember to click “Mark as Answer” on the post that helps you also "Unmark" if not
  This can be beneficial to other community members reading the thread.
  
  Regards,
  RamaSelvam M.
• • Reply
  micnie2020

  Member

  124 Points

  786 Posts

  Re: how to remove xml node diffgr:id="OpportunityElement1" msdata:rowOrder="0" using C#

  Apr 04, 2013 08:00 PM|micnie2020|LINK

  Hi,

   

  I want to export into .xml and used .xslt to transform the information.

   

  If the element node having that, it doesn't work at all.

   

  Please advise.

   

  Thank you.

  Regards,

  Micheale

• • Reply
  micnie2020

  Member

  124 Points

  786 Posts

  Re: how to remove xml node diffgr:id="OpportunityElement1" msdata:rowOrder="0" using C#

  Apr 04, 2013 08:19 PM|micnie2020|LINK

  Solved it.

   

  Refer to: http://www.rad.pasfu.com/index.php?/archives/37-Retrieve-Part-of-XML-File.html

   

  Regards,

  Micheale