How to read xml from string variable with particular tag

Question

we have to use some code for single root value, but we need multiple root elements and particular tag name to read data. We have to read xml string with particular tag name. Please advise ASAP Here is my code we have to use single root value its working fine, string xmlString = " 5/15/2018 test test Storyboarding "; XmlDocument doc = new XmlDocument(); doc.LoadXml(xmlString); XmlNodeList nodes = doc.DocumentElement.SelectNodes("//data"); StringBuilder yourString = new StringBuilder(); foreach (XmlNode node in nodes) { yourString.Append("Date:" + node["Date"].InnerText + " "); yourString.Append("Course:" + node["Course"].InnerText + ","); } PlaceHolder1.Controls.Add(new LiteralControl(yourString.ToString()));

Vishal Jadav · Answer

Hi, Dear create a method which should accept XML string and node name as string by converting XML string to dataset and read node as columns. like. DataSet XmlToDataset(string InputXml) { string MsgWithXml = Regex.Replace(InputXml, pattern, "$1"); XmlDocument xmldoc = new XmlDocument(); XmlTextReader ReadXml = new XmlTextReader(new StringReader(MsgWithXml)); ReadXml.Read(); DataSet Dset = new DataSet(); Dset.ReadXml(ReadXml, XmlReadMode.Auto); return Dset; } public string GetValueFromXml(string XmlAsString,string NodeName) { string Result = string.Empty; DataSet Dset = XmlToDataset(XmlAsString); foreach(DataTable dt in Dset.Tables) { if(dt.TableName == NodeName) { //if single row then loop through columns only like if(dt.Rows.Count > 0) foreach(DataColumn col in dt.Columns) { Result = Result + "Col=" + col.ColumnName + ", Value=" + dt.Rows[0][col.ColumnName].ToString(); } } } return Result; } Hope it helps..