C#

 foreach (XmlNode node in fieldNodes)
 {
     if (node.Attributes["name"].Value == "CDS")
     {
         for (int i = 0; i < node.ChildNodes.Count; i++)
         {
             if (node.ChildNodes[i].Attributes["id"].Value.ToString() == "Security")
             {
                 studentNode = node.ChildNode[i];
                <big> refNode = node;</big>
                 break;
             }
         }
     }
     if (studentNode != null)
         break;
 }
 XmlElement root = xmlDoc.DocumentElement;
 XmlElement newCd = xmlDoc.CreateElement("FieldType");
 newCd.SetAttribute("id", drChangedNode["id"].ToString());
 newCd.SetAttribute("name", drChangedNode["name"].ToString());
 newCd.SetAttribute("color", drChangedNode["color"].ToString());
 newCd.SetAttribute("type", drChangedNode["type"].ToString());
 newCd.SetAttribute("output", drChangedNode["output"].ToString());
 newCd.SetAttribute("description", drChangedNode["description"].ToString());
<big> refNode.ReplaceChild(newCd, studentNode);</big>
 xmlDoc.Save(filePath);

Syed Shahid Hussain wrote:

Thanks

I are Troll

GC.Collect();
GC.WaitForPendingFinalizers();
GC.Collect();//excel will close only after calling these methods twice
GC.WaitForPendingFinalizers();

try
{
    if (objAppln!= null)
        System.Runtime.InteropServices.Marshal.ReleaseComObject(objAppln);
}
catch (Exception)
{
    // ...
}
finally
{
    objAppln = null;
}

KaurGurpreet wrote:

What is wrong in the above code.

Marshal.ReleaseComObject(workBook);

I are Troll

IEqualityComparer<DataRow> comparer = DataRowComparer.Default;

DataRow rowOne = (DataRow)table.Rows[0];
DataRow rowTwo = (DataRow)table.Rows[1];

bool bEqual = comparer.Equals(rowOne, rowTwo);
if (bEqual)
    Console.WriteLine("The two rows are equal");
else
    Console.WriteLine("The two rows are not equal");