Following code illustrates about converting a DataTable to XML format. 
This is often required when passing a DataTable to a stored procedure. 
We can pass an XML directly to the procedure and process it.
private string ConvertDataTableToXML(DataTable dtBuildSQL)
{
  DataSet dsBuildSQL = new DataSet();
  StringBuilder sbSQL;
  StringWriter swSQL;
  string XMLformat;
  sbSQL = new StringBuilder();
  swSQL = new StringWriter(sbSQL);
  dsBuildSQL.Merge(dtBuildSQL, true, MissingSchemaAction.AddWithKey);
 dsBuildSQL.Tables[0].TableName = "Table";
 foreach (DataColumn col in dsBuildSQL.Tables[0].Columns)
 {
    col.ColumnMapping = MappingType.Attribute;
 }
 dsBuildSQL.WriteXml(swSQL);
 XMLformat = sbSQL.ToString();
 return XMLformat;
} 
 
No comments:
Post a Comment