IDC资讯中心
| write relational data to an xml file |
| submitted by | user level | date of submission |
| mahesh chand | beginner | 03/15/2001 |
the dataset class can be used to read a relational database table and write this table to an xml file. you use writexmldata or writexml class to write a dataset data to an xml file.
in this sample example, i have used access 2000 database, mydb.mdb. this database has a table, mytable.
| adodatasetcommand adocmd = new adodatasetcommand( "select * from mytable", "provider=microsoft.jet.oledb.4.0;data source=mydb.mdb" ); dataset ds = new dataset(); adocmd.filldataset(ds,"mytable"); ds.writexmldata("reldata.xml"); |
writexmldata method takes one parameter and that is xml file name which stores the data from the database.
