如何把数据集转变成XML例如:数据库中数据:
Table:T_User
-----------------
ID Name
-----------------
1 张三
2 李四
3 王五变为XML<T_User>
<Row>
<ID>1</ID>
<Name>张三</Name>
</Row>
<Row>
<ID>2</ID>
<Name>李四</Name>
</Row>
<Row>
<ID>3</ID>
<Name>王五</Name>
</Row>
</T_User>
Table:T_User
-----------------
ID Name
-----------------
1 张三
2 李四
3 王五变为XML<T_User>
<Row>
<ID>1</ID>
<Name>张三</Name>
</Row>
<Row>
<ID>2</ID>
<Name>李四</Name>
</Row>
<Row>
<ID>3</ID>
<Name>王五</Name>
</Row>
</T_User>
string constr = "server=UMI;database=NorthWind;uid=sa;password=sa;"; SqlConnection cn = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand("select * from T_User");
cmd.Connection = cn;
SqlDataAdapter da = new SqlDataAdapter(cmd);
cn.Open();
da.Fill(ds1);
cn.Close(); ds1.WriteXml("文件名");
ds.WriteXml();
DataSet是可以和XML对应的
ds.WriteXml("D:\\sample.xml");//這裡寫路徑,文件名字.ds.GetXml("D:\\sample.xml")//得到XML,並轉成數據集.
SqlDataAdapter da = new SqlDataAdapter("select * from T_User;", con); DataSet ds = new DataSet();
da.Fill(ds);
ds.WriteXml("filename.xml");
SqlDataAdapter da = new SqlDataAdapter("select * from #table;", MYcon ); DataSet MYds = new DataSet();
da.Fill(MYds );
MYds .WriteXml("MYfile.xml");