Spread Windows Forms 6.0 Product Documentation
Serialize(XmlTextWriter,Boolean) Method
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.Model Namespace > DefaultSheetDataModel Class > Serialize Method : Serialize(XmlTextWriter,Boolean) Method


w
XmlTextWriter object to which to save the object
saveDataSource
Whether to save the data source and bound data

Glossary Item Box

Saves the object to XML and specifies whether to save the data source and bound data.

Syntax

Visual Basic (Declaration) 
Public Overloads Function Serialize( _
   ByVal w As XmlTextWriter, _
   ByVal saveDataSource As Boolean _
) As Boolean
Visual Basic (Usage)Copy Code
Dim instance As DefaultSheetDataModel
Dim w As XmlTextWriter
Dim saveDataSource As Boolean
Dim value As Boolean
 
value = instance.Serialize(w, saveDataSource)
C# 
public bool Serialize( 
   XmlTextWriter w,
   bool saveDataSource
)

Parameters

w
XmlTextWriter object to which to save the object
saveDataSource
Whether to save the data source and bound data

Example

This example serializes the model and its data source.
Visual BasicCopy Code
Dim ds As New DataSet()
Dim emp As New DataTable("Employees")
Dim div As New DataTable("Division")
emp.Columns.Add("LastName")
emp.Columns.Add("FirstName")
emp.Rows.Add(New Object() {"Jones", "Marianne"})
emp.Rows.Add(New Object() {"Fieldes", "Anna"})
div.Columns.Add("Section")
div.Columns.Add("Specialty")
div.Rows.Add(New Object() {"Finance", "Taxes"})
div.Rows.Add(New Object() {"Mergers", "Legal"})
ds.Tables.AddRange(New DataTable() {emp, div})
Dim dataModel As New FarPoint.Win.Spread.Model.DefaultSheetDataModel()
dataModel.DataSource = ds
dataModel.DataMember = "Division"
FpSpread1.ActiveSheet.Models.Data = dataModel
Dim fileName As String
Dim stream As System.IO.Stream
Dim writer As System.Xml.XmlTextWriter
fileName = "D:\Temp\myser.xml"
stream = System.IO.File.Open(fileName, System.IO.FileMode.Create)
writer = New System.Xml.XmlTextWriter(stream, System.Text.Encoding.UTF8)
writer.Formatting = System.Xml.Formatting.Indented
writer.Indentation = 2
writer.WriteStartDocument()
writer.WriteStartElement("DataModel")
dataModel.Serialize(writer, True)
writer.WriteEndElement()
writer.WriteEndDocument()
writer.Close()
C#Copy Code
DataSet ds = new DataSet();
DataTable emp = new DataTable("Employees");
DataTable div = new DataTable("Division");
emp.Columns.Add("LastName");
emp.Columns.Add("FirstName");
emp.Rows.Add(new Object[] {"Jones", "Marianne"});
emp.Rows.Add(new Object[] {"Fieldes", "Anna"});
div.Columns.Add("Section");
div.Columns.Add("Specialty");
div.Rows.Add(new Object[] {"Finance", "Taxes"});
div.Rows.Add(new Object[] {"Mergers", "Legal"});
ds.Tables.AddRange(new DataTable[] {emp, div});
FarPoint.Win.Spread.Model.DefaultSheetDataModel dataModel = new FarPoint.Win.Spread.Model.DefaultSheetDataModel(5, 5);
dataModel.DataSource = ds;
dataModel.DataMember = "Division";
fpSpread1.ActiveSheet.Models.Data = dataModel;
string fileName = "D:\\Temp\\myser.xml";
System.IO.Stream stream = System.IO.File.Open(fileName, System.IO.FileMode.Create);
System.Xml.XmlTextWriter writer = new System.Xml.XmlTextWriter(stream,     System.Text.Encoding.UTF8);
writer.Formatting = System.Xml.Formatting.Indented;
writer.Indentation = 2;
writer.WriteStartDocument();
writer.WriteStartElement("DataModel");
dataModel.Serialize(writer, true);
writer.WriteEndElement();
writer.WriteEndDocument();
writer.Close();

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.