transforming XML Using XSLT need guidelines on how to

Question

I have to transform a very large xml document to html form and I have no idea on how to start the whole process. Help on the matter please as i am getting my xml from an xml field in the sql server.

Manas Mohapatra · Answer

Hi Tumelo You can transform xml data to xslt format to data display in multiple ways: With XML Control XslCompiledTransform class Without XML control Please go through below article: http://www.c-sharpcorner.com/UploadFile/manas1/display-xml-data-as-html-using-xslt-in-Asp-Net/

Tumelo Molefe · Answer

It seems like it is encrypting the xml when it saves it and then when i retrieve i need to be able to decrpyt it and then change back the tags that were changed by saving

Manas Mohapatra · Answer

Hi Tumelo First try to find where it as adding < to your xml Second why it is happening Thirdly come back with your input I can suggest you something. But be specific and clear to your answer.

Tumelo Molefe · Answer

Could You Please guide me on how to go about it when retrieving and saying the file so it saves like a regular XML File

Manas Mohapatra · Answer

Your XML data should like below Success But instead of that your code is converting to > So one suggestion will be when you are saving XML just replace the char and save it proper one.

Tumelo Molefe · Answer

How should i go about doing that? cause when I pass it to the div tag it shows in correct format

Manas Mohapatra · Answer

Your XML data is not correct in format. It is encoded to HTML tag element like So xslt is not able to read XML tags properly. Please make correct in XML it will start working.

Tumelo Molefe · Answer

Thank you Manas for the answer but now i have one problem as i pass the xml it returns in the original format using System; using System.Collections.Generic; using System.Data.SqlClient; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Xml; using System.Data; using System.Xml.Linq; using System.Configuration; using System.Xml.Xsl; using System.Text; using System.IO; public partial class Default2 : System.Web.UI.Page { protected void Page_Load(object sender EventArgs e) { } protected void Button1_Click(object sender EventArgs e) { SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[ICDBConnectionString].ConnectionString); conn.Open(); string SQL = Select TUReportData from TUReport WHERE ConsumerID = @ConsumerID; SqlCommand cmd = new SqlCommand(SQL conn); cmd.Parameters.Add(new SqlParameter(@ConsumerID txtIDNumber.Text)); SqlDataAdapter adapter = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); adapter.Fill(dt); dt.TableName = XMLData; dt.ToString(); dt.WriteXml(C:/inetpub/wwwroot/TUWebServiceCaller/Log/temp.xml); // Getting file path string strXSLTFile = Server.MapPath(styles/style.xslt); string strXMLFile = Server.MapPath(Log/temp.xml); // Creating XSLCompiled object XslCompiledTransform objXSLTransform = new XslCompiledTransform(); objXSLTransform.Load(strXSLTFile); // Creating StringBuilder object to hold html data and creates TextWriter object to hold data from XslCompiled.Transform method StringBuilder htmlOutput = new StringBuilder(); TextWriter htmlWriter = new StringWriter(htmlOutput); // Creating XmlReader object to read XML content XmlReader reader = XmlReader.Create(strXMLFile); // Call Transform() method to create html string and write in TextWriter object. objXSLTransform.Transform(reader null htmlWriter); Results.InnerHtml = htmlOutput.ToString(); // Closing xmlreader object reader.Close(); Could you please help me figure out what i have done wrong and i have attached the xml and xslt file

transforming XML Using XSLT, need guidelines on how to