Get XML from DataSet and convert into html using xslt dynamuically

protected void UseXslt()
{
XmlDocument xDS = new XmlDocument();
DataSet ds = new DataSet();
// ds = // Get DataSet from  DataBase.
xDS.LoadXml(ds.GetXml());
string sType = string.Empty;

// Get Value From Node
sType = xDS.DocumentElement.SelectSingleNode(“Data/Type”).InnerText;

// Add new Node in Existing XML
XmlElement xEml = xDS.CreateElement(“BType”);
xEml.InnerText = “Hi”;
xDS.DocumentElement.SelectSingleNode(“Data”).AppendChild(xEml);

string _xsltPath = string.Empty;
_xsltPath = “~/Users/User.xslt”;
XsltArgumentList xslArg = new XsltArgumentList();
string _resultHtml = String.Empty;
_resultHtml =ConvertXMLFromXSLT(xDS.OuterXml, _xsltPath, xslArg);
UserData.InnerHtml = _resultHtml;// <div id=”UserData” runat=”server”></div>  in  aspx page
}
public static string ConvertXMLFromXSLT(string XmlName, string XSLTFileName, XsltArgumentList arg)
{
XslCompiledTransform objXSL = new XslCompiledTransform();
// XsltArgumentList args = new XsltArgumentList();
XmlDocument XmlDoc = new XmlDocument();
string convertedXML = String.Empty;
XmlDoc.LoadXml(XmlName);
objXSL.Load(XSLTFileName);
try
{
XmlWriterSettings objSettings = new XmlWriterSettings();
objSettings.ConformanceLevel = ConformanceLevel.Auto;
System.Text.StringBuilder sb = new System.Text.StringBuilder(“”);
XmlWriter objXML = XmlWriter.Create(sb, objSettings);
objXSL.Transform(XmlDoc, arg, objXML);
convertedXML = sb.ToString();
}
catch (Exception ex)
{

}
return convertedXML;
}

Posted on