Auto Increment ID stuck at 10 when ID get 2 digit value

Viewed 80

In an xml file, I insert values to it. I give the Id numbers automatically for each Flight entered. The values are added into the Id 10 object automatically after ID gets 2 digit value. How can i solve this ?

XDocument xDoc = XDocument.Load(inputpath);
            var userElements = xDoc.Descendants("Flight").ToList();
            string lastID = userElements.Select(x => (x.Attribute("ID").Value))
                  .OrderByDescending(x => x)
                  .First()
                  .ToString();
            int lastID_dbl = Int32.Parse(lastID);

  <Flight ID="10" Description="10test" Date="9/10/2022 12:00:00 AM">
    <Instructor Num="10">
      <Name>10test</Name>
      <Surname>10test</Surname>
      <Rank>10test</Rank>
    </Instructor>
    <Instructor Num="11">
      <Name>11test</Name>
      <Surname>11test</Surname>
      <Rank>11test</Rank>
    </Instructor>
  </Flight>
  <Flight ID="10" Description="11test" Date="9/10/2022 12:00:00 AM" />
1 Answers

This solved my problem

var file = XDocument.Load(inputpath);    
int lastID_dbl = file.Descendants("Flight")
                               .OrderByDescending(x => Convert.ToInt32(x.Attribute("ID").Value))
                               .Select(x => Convert.ToInt32(x.Attribute("ID").Value))
                               .FirstOrDefault() + 1;
Related