Serialize and deserialize a able using writexml and readxml

Tag: Serialization and deserialization

This article describes how to use writexml and readxml to serialize and deserialize a able. "able does not support schema inference from XML. "Error.

Because datatable implements the iserializable and ixmlserializable interfaces, it supports serialization and deserialization.

Datatable is a good data type.

1. The tables in the Database correspond completely.

2. repleater, DataGrid, and other controls support binding to it.

3. Loop traversal in the Code is particularly convenient.

However, for network transmission or offline storage, the deserialization needs to be serialized into XML. writexml, and readxml is used to achieve the next goal.

1. Use writexml to serialize the able:

Prepare data:

1. Create Table sitemaps
2. (
3. URL varchar (255 ),
4. Title varchar (255)
5. )
7. Insert sitemaps
8. Select 'HTTP: // www.it118.org ', 'it think tank net'
9. Union all
10. Select 'HTTP: // bbs.it118.org ', 'it think tank network BBS'

C # Processing code:

1. Sqlconnection connection = new sqlconnection ("Server = localhost; database = testdb; uid = sa; Pwd = sa ");
3. Connection. open ();
5. Sqlcommand selectcommand = new sqlcommand (string. Format ("select * From sitemaps"), connection );
7. Datatable = new datatable ("sitemaps"); // note that table must have tablename
   
8. New sqldataadapter (selectcommand). Fill (datatable );
10. Connection. Close ();
12. Datatable. writexml ("D: \ sitemaps. xml ");

Sitemaps. xml:

1. <? XML version = "1.0" standalone = "yes"?>
2. <Documentelement>
3. <Sitemaps>
4. <URL> http://www.it118.org </URL>
5. <Title> it Think Tank Network </title>
6. </Sitemaps>
7. <Sitemaps>
8. <URL> http://bbs.it118.org </URL>
9. <Title> it Think Tank Network Forum </title>
10. </Sitemaps>
11. </Documentelement>

Ii. Use readxml to serialize the able:

If the code is as follows:

1. Datatable dt = new datatable ();
2. DT. readxml ("D: \ sitemaps. xml ");

The following message is displayed:Datatable does not support schema inference from XML.

The correct code is as follows:

1. Datatable dt = new datatable ("sitemaps ");
2. DT. Columns. Add ("url ");
3. DT. Columns. Add ("title ");
4. DT. readxml ("D: \ sitemaps. xml ");

3. Application

I used to have special requirements. I used writexml to generate xml locally and transmit it to other places to read it using readxml.