Modifying a node in XML - C# Discussion Boards

21-Apr-10 22:38

Hi,
I would like to modify the below xml where AssetClass name="CDS" and fieldType id= SECURITY. The below code is throwing exception at root.ReplaceChild... line "The node to be removed is not a child of this node.". Please correct it.. Thanks in advance.

 <?xml version="1.0" encoding="windows-1251" ?> 
 <MSGTaggingConfig version="1.0">
 <AssetClassConfiguration>
 <GlobalTypes>
  <FieldType id="F_TICKER" name="Ticker/Alias" color="#FF6600" type="S" output="false" description="Ticker Description" /> 
  <FieldType id="F_COUPON" name="Coupan/Alias" color="#FF3300" type="S" output="false" description="Ticker Description" /> 
  <FieldType id="F_BID" name="Bid Price" color="#FF9900" type="S" output="false" description="Bid Price Description" /> 
  <FieldType id="F_ASK" name="Ask Price" color="#FFCC00" type="S" output="false" description="Ask Price Description" /> 
  <FieldType id="F_TRENOR" name="Trenor" color="#FFCC33" type="S" output="false" description="Trenor Description" /> 
  <FieldType id="F_MATURITY" name="Maturity" color="#FFCC66" type="S" output="false" description="Maturity Description" /> 
  <FieldType id="F_ASSETQUALIFIER" name="Asset Qualifier" color="#CC9933" type="S" output="false" description="Asset Qualifier Description" /> 
  </GlobalTypes>
 <AssetClass id="AC_CDS" name="CDS" description="CDS Asset Class Description">
  <FieldType id="SECURITY" name="Security" color="#CC9900" type="C" output="true" description="Security Description" /> 
  <FieldType id="F_New" name="New Name" color="#008040" type="S" output="True" description="New Desc" /> 
  <FieldType id="F_New" name="New Name" color="Green" type="S" output="True" description="New desc" /> 
  <FieldType id="F_New" name="New Name" color="#80FF00" type="S" output="True" description="New Description" /> 
  </AssetClass>
</AssetClassConfiguration>
  </MSGTaggingConfig>

string filePath = Application.StartupPath + "\\MSGTaggingBackUp.xml";
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(filePath);
string xpath = string.Format("/MSGTaggingConfig/AssetClassConfiguration/AssetClass");
XmlNodeList fieldNodes = xmlDoc.SelectNodes(xpath);
XmlNode studentNode = null;
XmlNode refNode = null;

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]; 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());
root.ReplaceChild(newCd, studentNode);
xmlDoc.Save(filePath);

Estys22-Apr-10 0:27

Estys

22-Apr-10 0:27

Brad North wrote:
root.ReplaceChild(newCd, studentNode);

root has no child studentNode.
You must use the parent node from your foreach loop

NarVish22-Apr-10 1:35

22-Apr-10 1:35

I tried this way. Is this the way, you want me to do? I'm facing the same exception

foreach (XmlNode node in fieldNodes)
                {
                    if (node.Attributes["name"].Value == cmbAssetClass.Text)
                    {
                        for (int i = 0; i < node.ChildNodes.Count; i++)
                        {
                            if (node.ChildNodes[i].Attributes["id"].Value.ToString().ToUpper() == drChangedNode["id"].ToString().ToUpper())
                            {
                                studentNode = node;
                               break;
                              }
                        }
                    }
                    if (studentNode != null)
                        break;
                }

Estys22-Apr-10 2:29

Estys

22-Apr-10 2:29

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

Didn't try it, should work

NarVish22-Apr-10 2:39

Value change of Entity in a ObservableCollection<T>

22-Apr-10 2:39

Thank you, its working..

Saiyed Alam21-Apr-10 22:32

Saiyed Alam

21-Apr-10 22:32

Hello Friends

How can I know if value of any entity in a ObservableCollection<t> was changed or updated?

Thanking in Advance
Johnny

How to fetch file from a folder within.the application

NetMan201221-Apr-10 22:28

NetMan2012

21-Apr-10 22:28

Hello,

I have developed an application in c#, i have also done reporting in it. My application contains folder Reports with .rpt files in it. Currently i m giving the report file path as the full system directory path, i want to give the path directly by using my application boundary,not the complete path. how can i fetch the .rpt file path from the Reports folder, Plz help...

Re: How to fetch file from a folder within.the application

Ice_Freez0521-Apr-10 22:45

Ice_Freez05

21-Apr-10 22:45

try using Application.ExecutablePath and strip off the .exe file.

For example:

get the full name of the directory containing your .rpt file.

string strExeName = Application.ExecutablePath;
FileInfo fleExeFileInfo = new FileInfo(strExeName);
string strExeDirName = fleExeFileInfo.DirectoryName;

then get the parent directory of the .rpt by using...

string strParentDir = fleExeFileInfo.Directory.Parent.FullName;

hope this helps....

Re: How to fetch file from a folder within.the application

NetMan201221-Apr-10 23:04

NetMan2012

21-Apr-10 23:04

It worked, thanks alot Smile | :)

Re: How to fetch file from a folder within.the application

Anindya Chatterjee21-Apr-10 23:14

Anindya Chatterjee

21-Apr-10 23:14

By any chance are you not aware of Application.StartupPath ?? Then yo don't have to do all these string manipulations..

Regards,

Anindya Chatterjee[^]

DataGridView Grouping

Syed Shahid Hussain21-Apr-10 22:08

Syed Shahid Hussain

21-Apr-10 22:08

hi
I want to make grouping in the data grid view. like

Table 1
pk      col1         col2
1       ABC          51
2       DEF          74
-----------------------

Table 2
pk      col1       col2  col2  col3      fk(pk_table_1)
1       abc        3     23    111       1
2       def        3     45    74        1
3       kki        8     23    871       2
4       qwe        2     15    5         2
5       eed        7     41    91        2
------------------------------------------

Now I want to show the data in the grid but in summarized form. like only the data that is in table 1 will be displayed first and at the left most a + sign will be displayed when we press that the data of table 2 will be displayed then.

Thanks

Syed Shahid Hussain

Re: DataGridView Grouping

Eddy Vluggen22-Apr-10 1:34

Eddy Vluggen

22-Apr-10 1:34

Syed Shahid Hussain wrote:
Thanks

There's no question in this post, that makes it somewhat harder to formulate an answer.

AFAIK, the requested behaviour isn't standard available in the DataGridView. It might be best to look for a 3d-party grid that supports drill-down and grouping.

I are Troll Suspicious | :suss:

Excel remains in memory

KaurGurpreet21-Apr-10 21:28

KaurGurpreet

21-Apr-10 21:28

I have written the simple code as below:
Addede reference (C:\Program Files\Microsoft Visual Studio 9.0\Visual Studio Tools for Office\PIA\Office11\Microsoft.Office.Interop.Excel.dll)

private void button1_Click(object sender, EventArgs e)
{
Microsoft.Office.Interop.Excel.Application _objAppln;
Microsoft.Office.Interop.Excel.Workbook _objWorkBook=null ;

_objAppln = new Microsoft.Office.Interop.Excel.Application(); // To initialize excel file

if (_objAppln != null)
{
_objWorkBook = _objAppln.Workbooks.Add(Type.Missing); // To add workbook with sheets in excel file
//_objWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)_objWorkBook.ActiveSheet; // To get the current active sheet in excel file
}
string _fileName = "temp.xls";

_objWorkBook.SaveAs(_fileName,
Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, Type.Missing, Type.Missing, false, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
_objWorkBook.Close(true, _fileName, false);

_objAppln.Quit();
_objWorkBook = null;
_objAppln = null;
}

After the code is execuled, the instance of Excel (EXCEL.exe) is seen in taskbar. I have as many number of instances, as many times I click on the button.
The instance exists even when I stop the application.

What is wrong in the above code.

Gurpreet

m@u21-Apr-10 21:57

m@u

21-Apr-10 21:57

Hi
I had the same problem

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

after setting _objAppln=null; worked for me
greets

KaurGurpreet21-Apr-10 22:32

KaurGurpreet

21-Apr-10 22:32

Explicitly calling GC.collect is not recommended. Is there any other good way to handle it?

Gurpreet

Mirko198022-Apr-10 0:42

Mirko1980

22-Apr-10 0:42

Try releasing the Excel Application COM object by using the following code:

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

Eddy Vluggen22-Apr-10 2:31

Eddy Vluggen

22-Apr-10 2:31

KaurGurpreet wrote:
What is wrong in the above code.

~~I'm missing the code to close the workbook and exit the Excell application.~~

Meh, they're there, just overlooked them.

This kb-article[^] might help. The only other alternative[^] that I can offer;

Marshal.ReleaseComObject(workBook);

I are Troll Suspicious | :suss:

Compare two datarows

NarVish21-Apr-10 21:15