如何将数据库中数据源生成xml文件 sql server

Question

我是想把查询的结果生成xml让前台接收然后再报表上显示出来，继续请教

Answer 1

List<Area> list = a.GetAllAreaById(id);
//将list集合序列化到流中
MemoryStream stream = new MemoryStream();
XmlSerializer s = new XmlSerializer(typeof(List<Area>));
s.Serialize(stream, list);
//将流转换成字节数组，再解码为字符串
string ss = System.Text.Encoding.UTF8.GetString(stream.ToArray());
XmlDocument dom = new XmlDocument();
dom.LoadXml(ss);

Response.ContentType = "text/xml";
Response.Charset = "utf-8";
HttpContext.Current.Response.Write(dom.OuterXml);

Answer 2

xml --> sql server
http://community.csdn.net/Expert/topic/5041/5041228.xml?temp=.8233911