How to read xml from string variable with particular tag

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/2018test testStoryboarding";

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()));

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..

1 Reply

Know the answer? Post it — somebody with the same question will find it here.