C#

<br />
 public virtual bool TransformXML2( string strTempXml, ref string strTransformedXml )<br />
        {<br />
            bool bSuccess = true;<br />
            if (m_strTransformFile.Length == 0)<br />
            {<br />
                PIUUtilitiesMgr.PIUMessage(PIUUtilitiesMgr.GetResourceString("MISSING_XSLT_FILE_NAME"), PIUUtilitiesMgr.GetResourceString("PERSONNEL_IMPORT_UTILITY"), MessageBoxButtons.OK);<br />
                return false;<br />
            }<br />
<br />
            //Create Dom object and transform with XSL file<br />
            try<br />
            {<br />
<br />
                System.IO.MemoryStream streamTempData = new System.IO.MemoryStream();<br />
                PIUUtilitiesMgr.FromStringToMemoryStream(streamTempData, strTempXml);<br />
                string outText = PIUUtilitiesMgr.MemoryStreamToString(streamTempData);<br />
<br />
                PIUUtilitiesMgr.WriteToFileForDebuggingPurpose("TempUserList.xml", outText, true);<br />
<br />
                //Transform<br />
                System.IO.MemoryStream streamTransformedData = new System.IO.MemoryStream();<br />
                //Create a reader to read the stream<br />
                streamTempData.Position = 0;<br />
<br />
<br />
                XmlReader reader = XmlReader.Create(streamTempData);<br />
                XslCompiledTransform xslTransform = new XslCompiledTransform(true);<br />
<br />
                XsltSettings settings = new XsltSettings(true, true);<br />
                //xslTransform.Load(m_strTransformFile);<br />
                xslTransform.Load(m_strTransformFile, settings, new XmlUrlResolver());<br />
<br />
                xslTransform.Transform(reader, null, streamTransformedData);<br />
<br />
                //set position to 0<br />
                streamTransformedData.Position = 0;<br />
<br />
                //Convert this to string<br />
                strTransformedXml = PIUUtilitiesMgr.MemoryStreamToString(streamTransformedData);<br />
<br />
                // we get ??? at the top of the file and need to get rid of it.<br />
                strTransformedXml = strTransformedXml.Remove(0, 1);<br />
                streamTransformedData.Close();<br />
                streamTransformedData.Dispose();<br />
                streamTempData.Close();<br />
                streamTempData.Dispose();<br />
<br />
<br />
<br />
                //If debug write this to file<br />
               <br />
                if (piuInfo.DebugMode)<br />
                {<br />
                    lock (this)<br />
                    {<br />
                        PIUUtilitiesMgr.WriteToFileForDe1buggingPurpose("TransformedUserList.xml", strTransformedXml, true);<br />
                    }<br />
                }<br />
<br />
            }<br />
<br />

        // 2. Start DataGridView "dataGridView2". <br />
        // 2a. create a mysql DataAdapter<br />
        OdbcAd = new System.Data.Odbc.OdbcDataAdapter("SELECT * FROM " + SelectedTableName + ";", OdbcCon);<br />
<br />
        // 2b. create a dataset<br />
        DataSet myds = new DataSet();<br />
<br />
        // 2c. now fill and bind the DataGrid<br />
        OdbcAd.Fill(myds, SelectedTableName);<br />
<br />
        // 2d. dataGridView1.DataSource = myds;<br />
        dataGridView2.DataSource = myds.Tables[SelectedTableName];