to convert passed dataset to XML data public string ConvertDataSetToXML(DataSet xmlDS) { MemoryStream stream = null ; XmlTextWriter writer = null ; try { stream = new MemoryStream(); / / Load the XmlTextReader from the stream writer = new XmlTextWriter(stream, Encoding.Unicode); / / Write to the file with the WriteXml method. xmlDS.WriteXml(writer); int Close(); } } Now let look at saving this XML TO DataBase. . . DataSet reportData = new DataSet(); reportData.ReadXml(Server.MapPath(”report.xml”)); SqlConnection connection = new SqlConnection(”CONNECTION STRING”); SqlBulkCopy sbc = new SqlBulkCopy(connection); sbc.DestinationTableName = “report_table
0in 5.4pt 0in 5.4pt'> style = 'text-align:center'> select = "format-number(sum(NewDataSet / Report / kbytes) div 1024, '###, ###, ##0.###')" / > white 2.25pt;background: #F2F2F2;padding:0in 5.4pt 0in 5.4pt'> style = 'text-align:center'> select = "format-number(sum(NewDataSet / Report / count), '###, ###, ##0')" / > 5.4pt 0in 5.4pt'> style = 'text-align:center'> select = "format-number(sum NewDataSet / Report / pages), '###, ###, ##0.#')" / > basis is shown below:< / p> cellpadding = "0" style = 'border-collapse:collapse;mso-yfti 5.4pt'> style = 'text-align:center;mso-yfti-cnfc:64'> select = "format-number(sum(NewDataSet / Report / kbytes) div 1024, '###, ###, ##0.###')" / > white 2.25pt;mso-border-top-alt: solid white 2.25pt 5.4pt'> style = 'text-align:center;mso-yfti-cnfc:64'> select = "format-number(sum(NewDataSet / Report / count), '###, ###, ##0')" / > style = 'border:none;mso-border-top-alt:solid white 2.25pt; mso-border 5.4pt'> style = 'text-align:center;mso-yfti-cnfc:64'> select = "format-number(sum(NewDataSet / Report / pages), '###, ###, ##0.#')" / > Here is the C# code: private void RenderReport(string reportXml, string sXsltFile, string sOutfile, int nOption ) { / / Option 1 = detailed, 2 = summary DisplayStatusMsg(0, "Processing"); DisplayStatusMsg(1, "Creating detailed report " + sOutfile); Application.DoEvents(); try { / / read data for this report StreamReader reader = new StreamReader(reportXml); / / preps xml to be transformed XPathDocument document = new XPathDocument(reader
_schema.Id = _tableName; } } System.Xml.Schema.XmlSchema IXmlSerializable.GetSchema() { throw new System.NotImplementedException(); } void IXmlSerializable.ReadXml(System.Xml.XmlReader reader) { base.ReadXml(reader); } void IXmlSerializable.WriteXml(System.Xml.XmlWriter writer) { base.WriteXml(writer, XmlWriteMode.DiffGram); } private void GetTableSchema() { System.IO.MemoryStream stream = new System.IO.MemoryStream(); this.WriteXmlSchema(new System.Xml.XmlTextWriter(stream, null)); stream.Position = 0; _schema = XmlSchema.Read(new System.Xml.XmlTextReader(stream), null); } public _schema.Id = _tableName; } } System.Xml.Schema.XmlSchema IXmlSerializable.GetSchema() { throw new System.NotImplementedException(); } void IXmlSerializable.ReadXml(System.Xml.XmlReader reader) { base.ReadXml(reader); } void IXmlSerializable.WriteXml(System.Xml.XmlWriter writer) { base.WriteXml(writer, XmlWriteMode.DiffGram); } private void GetTableSchema() { System.IO.MemoryStream stream = new System.IO.MemoryStream(); this.WriteXmlSchema(new System.Xml.XmlTextWriter(stream, null)); stream.Position = 0; _schema = XmlSchema.Read(new System.Xml.XmlTextReader(stream), null); } public Schema.XmlSchema IXmlSerializable.GetSchema() \ par \ { \ par throw new System.NotImplementedException(); \ par \ } \ par \ par void IXmlSerializable.ReadXml(System.Xml.XmlReader reader) \ par \ { \ par base.ReadXml(reader); \ par \ } \ par \ par void IXmlSerializable.WriteXml(System.Xml.XmlWriter writer) \ par \ { \ par base.WriteXml