怎样把数据库中的一条记录转换为xml?

[zwp315]

给我讲讲，十分感谢！

[blackcatiii]

select * from table1 for xml auto

[luoqing]

用dataset的 WriteXml()方法.
private void WriteXmlToFile(DataSet thisDataSet) {
if (thisDataSet == null) { return; }
// Create a file name to write to.
string filename = "myXmlDoc.xml";
// Create the FileStream to write with.
System.IO.FileStream myFileStream = new System.IO.FileStream
(filename, System.IO.FileMode.Create);
// Create an XmlTextWriter with the fileStream.
System.Xml.XmlTextWriter myXmlWriter =
new System.Xml.XmlTextWriter(myFileStream, System.Text.Encoding.Unicode);
// Write to the file with the WriteXml method.
thisDataSet.WriteXml(myXmlWriter);
myXmlWriter.Close();
}

[fly_miss]

gz ： blackcatiii(ljh)

[zxlh]

ds=new DataSet();
string conn="data source=zhangweiping;initial catalog=pubs;persist security info=False;user id=sa;workstation id=ZHANGWEIPING;packet size=4096";
SqlConnection newconn =new SqlConnection(conn);
String sCommand = "Select * from authors where au_id='172-32-1176'";

[zxlh]

是这个
try
{
myDataAdapter.Fill(ds,"authors");
}
catch(Exception ex){
Response.Write(ex.ToString());

}
XmlDataDocument doc = new XmlDataDocument(ds);


doc.Save("c:\\1.xml");
SqlDataAdapter myDataAdapter = new SqlDataAdapter(sCommand, newconn);
try
{
myDataAdapter.Fill(ds,"authors");
}
catch(Exception ex){
Response.Write(ex.ToString());

}
XmlDataDocument doc = new XmlDataDocument(ds);

[zwp315]

blackcatiii(ljh) ( ) 信誉：100 2003-02-24 09:50:00 得分:0


select * from table1 for xml auto
/////////
?什么意思？

[zwp315]

ds.WriteXml("c:\\11.xml");