第一个示例方法：

1 sqlconnection conn = new sqlconnection();

2 conn.connectionstring = server=127.0.0.1;user

id=sa;password=fdahgdrethj31313210212121;

database=northwind;persist security info=true;

3 conn.open();

4 sqldataadapter da = new sqldataadapter(select * from 表, conn);

5 sqlcommandbuilder thisbulder = new sqlcommandbuilder(da);

6 dataset ds = new dataset();

7 da.fill(ds);

8 ds.writexml(@c:\temp.xml);

第二个示例方法：

1 private void writexmltofile(dataset thisdataset)

2 {

3 if (thisdataset == null) { return; }

4 // create a file name to write to.

5 string filename = myxmldoc.xml;

6 // create the filestream to write with.

7 system.io.filestream myfilestream = new system.io.filestream

8 (filename, system.io.filemode.create);

9 // create an xmltextwriter with the filestream.

10 system.xml.xmltextwriter myxmlwriter =

11 new system.xml.xmltextwriter

(myfilestream, system.text.encoding.unicode);

12 // write to the file with the writexml method.

13 thisdataset.writexml(myxmlwriter);

14 myxmlwriter.close();

15 }

更多信息请查看IT技术专栏