C# How to delete element in XML

[Czechtim]

Hello,
I have this XML file players.xml

<players>
  <player>
    <name>administrator</name>
    <game>Cube</game>
    <na_tahu>true</na_tahu>
    <score>45</score>
    <partner></partner>
    <last_move></last_move>
  </player>
  <player>
    <name>User2</name>
    <game>Cube</game>
    <na_tahu>true</na_tahu>
    <score>16</score>
    <partner></partner>
    <last_move></last_move>
  </player>
</players>

And I need to delete this whole element

 <player>
    <name>User2</name>
    <game>Cube</game>
    <na_tahu>true</na_tahu>
    <score>16</score>
    <partner></partner>
    <last_move></last_move>
  </player>

I can identify this element according to child elements <name> and <game>. So if <name>.InnerText="User2" & <game>.InnerText="Cube" then delete <player>...</player>

But I don´t know how to write code in C# for finding that right element player. Could somebody please help me how to delete this element?

[PRR]

try this ...

{
                DataSet ds = new DataSet();
                ds.ReadXml(@"C:\File.Xml");
                int rowcount = 0;
                for (int i = 0; i < ds.Tables[0].Rows.Count;i++ )
                {
                    DataRow r = ds.Tables[0].Rows[i];
                    Console.WriteLine(r[0].ToString() + "");                    
 
                    if (r[0].ToString() == "User2")
                    {
                        DataView drv = new DataView(ds.Tables[0]);
                            //ds.Tables[0] as DataView ;
                        drv[rowcount].Delete();
                        ds.AcceptChanges();
                        ds.WriteXml(@"C:\File1.Xml");
 
                        //ds.Tables[0].Rows[i];
                    }
                    rowcount++;
                }
File.XML
<?xml version="1.0" encoding="utf-8" ?>  
<players>
   <player>
     <name>administrator</name>
     <game>Cube</game>
     <na_tahu>true</na_tahu>
     <score>45</score>
     <partner></partner>
     <last_move></last_move>
   </player>
   <player>
     <name>User2</name>
     <game>Cube</game>
     <na_tahu>true</na_tahu>
     <score>16</score>
     <partner></partner>
     <last_move></last_move>
   </player>
</players>
 
File1.Xml
<?xml version="1.0" standalone="yes"?>
<players>
  <player>
    <name>administrator</name>
    <game>Cube</game>
    <na_tahu>true</na_tahu>
    <score>45</score>
    <partner />
    <last_move />
  </player>
</players>
 
 

[PRR]

You could also serialize and deserialize a class... into a xml file ...