Navigation

Tuesday 26 November 2013

Convert a DataTable into String XML in C#

     By this code you can convert dataTable to Xml and Then SqlXml to pass in DataBase by Procedure


    private SqlXml fnXmlString(DataTable dt)
    {
         using (StringWriter sw = new StringWriter())
            {
                dt.TableName = "SCHED";
                dt.WriteXml(sw);
                StringReader transactionXml = new StringReader(sw.ToString());
                XmlTextReader xmlReader = new XmlTextReader(transactionXml);
                SqlXml sqlXml = new SqlXml(xmlReader);              
                return sqlXml;
            }      
    }

// Calling function

 SqlXml sqlXml = fnXmlString(dt);  

No comments:

Post a Comment