如何把数据库里的数据用XML的形式读出来

来源:百度知道 编辑:UC知道 时间:2024/05/14 11:18:15

string sql = "SELECT id,name FROM content FOR XML AUTO,XMLDATA";
SqlConnection conn =new SqlConnection("server=.;uid=sa;database=TextProject" );
SqlCommand cmd=new SqlCommand(sql,conn);
conn.Open();
XmlTextReader objXmlReader = (XmlTextReader)cmd.ExecuteXmlReader();
DataSet ds = new DataSet();
ds.DataSetName = "XML";
ds.ReadXml(objXmlReader,XmlReadMode.Fragment);
ds.WriteXml(Server.MapPath("XML.xml"));
conn.Close();