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