Insert, update and delte records from xml file

[Bader]

Hello,

I'm a new developer of winforms.
I'm trying to insert, update and delete records from the following xml file using the radgridview control (I'm using the 2009.3.9.1203 version):

"

<?xml version="1.0" encoding="utf-16"?>
<uTemplateData xmlns:i="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://********************************************">
  <GoodData xmlns:dppp2="http://***************************************************************************">

    <dppp2:LVPrm>
      <dppp2:Bnr i:nil="true" />
      <dppp2:CCount>2</dppp2:CCount>
      <dppp2:OSV>8542</dppp2:OSV>
      <dppp2:ParentId>0</dppp2:ParentId>
      <dppp2:RMM>2048</dppp2:RMM>
      <dppp2:bName i:nil="true" />
      <dppp2:bFvr>CHK</dppp2:bFvr>
      <dppp2:customSName></dppp2:customSName>
      <dppp2:hst>V42</dppp2:hst>
      <dppp2:mPath i:nil="true" />
      <dppp2:nNames xmlns:dppp4="http://********************************************************">
        <dppp4:string>MyName</dppp4:string>
      </dppp2:nNames>
      <dppp2:nGuids xmlns:dppp4="http://*********************************************************">
        <dppp4:string>My2Name</dppp4:string>
      </dppp2:nGuids>
      <dppp2:pArch>None</dppp2:pArch>
      <dppp2:sType>ATUP</dppp2:sType>
      <dppp2:uUM>false</dppp2:uUM>
      <dppp2:vtName>5u_4{Counter}</dppp2:vtName>
      <dppp2:vtType>mor</dppp2:vtType>
      <dppp2:trIp xmlns:dppp4="http://**********************************************************">
        <dppp4:mAd>73111160</dppp4:mAd>
        <dppp4:mFam>InterNetwork</dppp4:mFam>
        <dppp4:mHsh>0</dppp4:mHsh>
        <dppp4:mNmb xmlns:dppp5="http://*********************************************************">
          <dppp5:uShort>0</dppp5:uShort>
          <dppp5:uShort>0</dppp5:uShort>
          <dppp5:uShort>0</dppp5:uShort>
          <dppp5:uShort>0</dppp5:uShort>
          <dppp5:uShort>0</dppp5:uShort>
          <dppp5:uShort>0</dppp5:uShort>
          <dppp5:uShort>0</dppp5:uShort>
          <dppp5:uShort>0</dppp5:uShort>
        </dppp4:mNmb>
        <dppp4:mScpId>0</dppp4:mScpId>
      </dppp2:trIp>
      <dppp2:tCrName>ctii_rl</dppp2:tCrName>
      <dppp2:tEName>Nwa</dppp2:tEName>
      <dppp2:tPName>AutoDefault</dppp2:tPName>
    </dppp2:LVPrm>

    <dppp2:LVPrm>
      <dppp2:Bnr i:nil="true" />
      <dppp2:CCount>2</dppp2:CCount>
      <dppp2:OSV>8542</dppp2:OSV>
      <dppp2:ParentId>0</dppp2:ParentId>
      <dppp2:RMM>2048</dppp2:RMM>
      <dppp2:bName i:nil="true" />
      <dppp2:bFvr>CHK</dppp2:bFvr>
      <dppp2:customSName></dppp2:customSName>
      <dppp2:hst>V42</dppp2:hst>
      <dppp2:mPath i:nil="true" />
      <dppp2:nNames xmlns:dppp4="http://********************************************************">
        <dppp4:string>MyName</dppp4:string>
      </dppp2:nNames>
      <dppp2:nGuids xmlns:dppp4="http://*********************************************************">
        <dppp4:string>My2Name</dppp4:string>
      </dppp2:nGuids>
      <dppp2:pArch>None</dppp2:pArch>
      <dppp2:sType>ATUP</dppp2:sType>
      <dppp2:uUM>false</dppp2:uUM>
      <dppp2:vtName>5u_4{Counter}</dppp2:vtName>
      <dppp2:vtType>mor</dppp2:vtType>
      <dppp2:trIp xmlns:dppp4="http://**********************************************************">
        <dppp4:mAd>7311160</dppp4:mAd>
        <dppp4:mFam>InterNetwork</dppp4:mFam>
        <dppp4:mHsh>0</dppp4:mHsh>
        <dppp4:mNmb xmlns:dppp5="http://*********************************************************">
          <dppp5:uShort>0</dppp5:uShort>
          <dppp5:uShort>0</dppp5:uShort>
          <dppp5:uShort>0</dppp5:uShort>
          <dppp5:uShort>0</dppp5:uShort>
          <dppp5:uShort>0</dppp5:uShort>
          <dppp5:uShort>0</dppp5:uShort>
          <dppp5:uShort>0</dppp5:uShort>
          <dppp5:uShort>0</dppp5:uShort>
        </dppp4:mNmb>
        <dppp4:mScpId>0</dppp4:mScpId>
      </dppp2:trIp>
      <dppp2:tCrName>ctii_rl</dppp2:tCrName>
      <dppp2:tEName>Nwa</dppp2:tEName>
      <dppp2:tPName>AutoDefault</dppp2:tPName>
    </dppp2:LVPrm>


  </GoodData>
</uTemplateData>

"
You see that the above xml is more complex than the xml file which supported the radgridview.
So, I'm asking you as new developer of winforms to help me step by step in order to insert, update and delete records from the above xml.

If the radgridview is not intended for supporing such xml files, Please, guide me how to achieve the requirement using another control.

It is appreciated to send me a code with an explaination.

Regards,
Bader

[Emanuel Varga]

Hello Bader,

I have to ask if you have the possibility to update to the latest version of telerik controls.
My main concern is that even if i help you with a solution, because i don't have the 2009 version a lot of this would not be compatible.

Best Regards,
Emanuel Varga
Telerik WinForms MVP

[Bader]

Hello,

Thank you for your reply,
Unfortunatily, I can't update to the latest version of telerik controls now.
Any way, I will be happy if you send me the solution. I will try it in the trial verion. because, I think I have to update it within the nearest few weeks.

Of course, I'm still looking for a good solution for the 2009.3.9.1203 version.

Regards,
Bader

[Martin Vasilev]

Hi Bader,

Thank you for writing.

RadGridView does not support direct binding to xml data. However, you can implement such a scenario by using a DataSet loaded from xml. You should be aware that RadGridView will be bound to the DataSet, but there is not a way to update the xml source like a database (for example with TableAdapter's Update method). Instead, you should use ReadXml method to load data, and WriteXml to save the changed data. You can find some details in our product documentation.

I also would second the Emanuel's advice for upgrading to the latest version. It contains a lot of bug fixes and improvements and this will allow us to provide you with quicker responses.

Best wishes,
Martin Vasilev
the Telerik team