How to read xml by using element name and save to table in sql database using C#

Hi,

Please refer below code.

C#

string text = @"<book><one><title>ABC</title></one><two><price>24.95</price></two></book>";
XmlTextReader reader = new XmlTextReader(new StringReader(text));
reader.WhitespaceHandling = WhitespaceHandling.None;
// Moves the reader to the 'book' node.
reader.MoveToContent(); 

// Moves the reader to the 'one' node.
reader.Read(); 
reader.MoveToContent();

// Reads the inner XML of the 'one' node, which is the entire 'title'
// node, and outputs <title>ABC</title>. 
Console.WriteLine(reader.ReadInnerXml()); 

// The reader is now positioned on the 'two' node.
Console.WriteLine(reader.Name);

// Calling Read will advance the reader beyond the 'two' node to 
// the 'price' node.
reader.Read();
// Outputs the node of 'price'.
Console.WriteLine(reader.Name);

If above code wont help you then share you xml data and expected result.