Question

如何将查询出的结果生成一个XML文件

Answer 1

比如说我有一个存储过程
create proc [dbo].[iSno_Select]
@sno nchar(7)
as
select sname,ssex,sage,sdept
from student
where sno=@sno

出一个查询结果，我在.Net里调用这个存储结果

string sno = TextBox1.Text.Trim();
string conStr = "Data Source=PC-20110624IRHP\\SQLEXPRESS;Initial Catalog=";
conStr = conStr + "students2;Integrated Security=sspi";
SqlConnection Con = new SqlConnection(conStr);
Con.Open();
string s = "iSno_Select '" + sno + "'";
SqlCommand cmd = new SqlCommand(s, Con);
SqlDataReader dr = cmd.ExecuteReader();

XmlDocument objDom=new XmlDocument();