Reads a specially formatted XML document that includes all changes, including before and after data, from a Stream.
[Visual Basic] Overloads Public Sub ReadDiffGram( _ ByVal stream As Stream _ ) [C#] public void ReadDiffGram( Stream stream ); [C++] public: void ReadDiffGram( Stream* stream ); [JScript] public function ReadDiffGram( stream : Stream );
The XML document (or "diffgram") can be read by SQLServer. An example of the format is shown below. The document can convey the before and after versions of data that has been added, modified, or deleted.
<DocumentElement xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:sql="urn:schemas-microsoft-com:xml-sql"> <sql:ssync> <!-- Deleted --> <sql:before> <Teachers sql:id="1"> <ID>0</ID> <Name>Mr Apple</Name> </Teachers> </sql:before> <sql:after></sql:after> <!-- Unchanged --> <sql:before> <Teachers sql:id="2"> <ID>1</ID> <Name>Mrs Blue</Name> </Teachers> </sql:before> <sql:after> <Teachers sql:id="2"></Teachers> </sql:after> <!-- New --> <sql:before></sql:before> <sql:after> <Courses sql:id="7"> <ID>6</ID> <Name>Home Ec 200</Name> </Courses> </sql:after> <!-- Modified --> <sql:before> <Students sql:id="1"> <ID>0</ID> <Name>Abe</Name> </Students> </sql:before> <sql:after> <Students sql:id="1"> <ID>0</ID> <Name>Abby</Name> </Students> </sql:after> <!-- Removed --> <sql:before> <Students sql:id="2"></Students> </sql:before> <sql:after> </sql:after> </sql:ssync> </DocumentElement>
DataSet Class | DataSet Members | System.Data Namespace | DataSet.ReadDiffGram Overload List | WriteDiffGram